Trending questions in Power BI

0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

Sep 24, 2020 in Power BI by Alisha
6,515 views
0 votes
1 answer

how to connect firebase data into power bi

Hi, @There, Click “Get Data->Blank Query” to add ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,770 points
2,771 views
0 votes
1 answer

how to create snapshots in power BI?

Snapshots enable faster loading of specific properties. Follow ...READ MORE

Oct 29, 2019 in Power BI by Cherukuri
• 33,050 points
20,564 views
0 votes
1 answer

Couldn't retrieve the data for this visual.

The error you mentioned here is usually ...READ MORE

Nov 2, 2020 in Power BI by Gitika
• 65,770 points
4,466 views
0 votes
1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,770 points
2,551 views
0 votes
1 answer

Can't get client-credentials access token to authorize Power BI

With the assistance of some Microsoft folks ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,770 points
2,042 views
0 votes
1 answer

Slicer with conditions - if value selected,select related values

I assume that both tables are unrelated ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
3,598 views
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

Oct 29, 2020 in Power BI by Gitika
• 65,770 points
4,015 views
0 votes
1 answer

DAX Calculation the Max for a Group.

You can try this out:  Desired Output=CALCULATE(MAX([Check]), ...READ MORE

Sep 25, 2020 in Power BI by Gitika
• 65,770 points

edited Sep 25, 2020 by Gitika 5,447 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,770 points
4,769 views
0 votes
1 answer

How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,770 points
2,018 views
0 votes
1 answer

How to create summary table based on selected filters/slicers?

Here are the steps you can follow: 1. ...READ MORE

Nov 12, 2020 in Power BI by anonymous
• 65,770 points
3,133 views
0 votes
1 answer

Can we delete datasets in pro from works space in Power Bi

Hi, @Naveen, Please go through the given below ...READ MORE

Nov 26, 2020 in Power BI by Gitika
• 65,770 points
2,471 views
0 votes
1 answer

How can I make my visual distinct count total match the row by row sum when applying filters in PowerBI?

The COUNTROWS function can be used to ...READ MORE

Jul 28, 2020 in Power BI by Gitika
• 65,770 points
7,708 views
0 votes
1 answer

Is it possible to use R Plotly library in R Script Visual of Power BI?

For newer versions of PowerBI, it's also ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,770 points
1,719 views
0 votes
1 answer

Failed to load files, showing please wait while we establish a connection to <filename>'.

 One thing you can do is that ...READ MORE

Oct 22, 2020 in Power BI by anonymous
• 65,770 points
3,705 views
0 votes
1 answer

Direct Query Cannot Load Model. Login Failed for user. The exception was by raised by the IDbConnect

The current power bi pbix file connection ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
2,578 views
0 votes
1 answer

How to connect google sheet with power bi?

If you're not limited to R Studio, ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,770 points
1,004 views
0 votes
1 answer

How to calculate PowerBI / DAX - Row wise division by measure?

As for your question, I think you're ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,770 points
4,188 views
0 votes
1 answer

Task's Exception(s) were not observed.

I suggest you go the the "Files" - ...READ MORE

Nov 2, 2020 in Power BI by Gitika
• 65,770 points
3,097 views
0 votes
1 answer

Cannot install Microsoft Power Bi Postgre SQL connector

There seems to be some problem with ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,770 points
966 views
0 votes
0 answers

Tableau or PowerBI- which certification is better for an experienced BI person to get a job in Australia?

Um having experience of Informatica, SAP Business ...READ MORE

Jan 11, 2021 in Power BI by Edureka

edited Mar 4 26 views
0 votes
1 answer

how to sync firebase data into power bi?

Hi, @There, As far as I know, it ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,770 points
941 views
0 votes
1 answer

Cumulative distinct count filtered by last value - DAX

MyFilteredCumulativeMeasure = COUNTROWS( FILTER( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,770 points
2,207 views
0 votes
1 answer

How do I use Power BI Desktop with version control?

I would add a "Parameters" Query (a ...READ MORE

Dec 18, 2020 in Power BI by Gitika
• 65,770 points
866 views
0 votes
1 answer

Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,770 points
4,528 views
0 votes
1 answer

What is the difference Between SUM() and SUMX()

Sum function (Sum()) takes the data columns ...READ MORE

Oct 20, 2020 in Power BI by anonymous
• 65,770 points
3,328 views
0 votes
0 answers

how to connect appsflyer data to power bi

how to connect appsflyer data to power ...READ MORE

Dec 18, 2020 in Power BI by Edureka
• 160 points
808 views
0 votes
1 answer

Several errors occurred during data refresh.

"Connexion successful" mean "the network connection is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
2,105 views
0 votes
1 answer

PowerPivot DAX - Dynamic Ranking Per Group (Min Per Group)

Firstly create a basic measure [Amount] to sum the ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
1,968 views
0 votes
1 answer

user select on filter to show the bars

Hi, @There, There are multiple steps which you ...READ MORE

Dec 10, 2020 in Power BI by Gitika
• 65,770 points
920 views
0 votes
1 answer

DAX Previous Month to date total is giving entire previous month's entire total

You can go through this: PMYTD = ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,770 points
3,610 views
0 votes
1 answer

DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,770 points
4,182 views
0 votes
1 answer

How to use No QUARTER() in DAX in power BI?

One should use =ROUNDUP(MONTH([Date])/3, 0) to get quarte ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,770 points
909 views
0 votes
1 answer

Is it possible to use multiple dataset for one report?

Yes, of course, you can load a few ...READ MORE

Oct 29, 2020 in Power BI by Gitika
• 65,770 points
2,566 views
0 votes
1 answer

Error Error on Data load when open report in server "An error has occurred"

The problem you can solve by edit this ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
1,714 views
0 votes
1 answer

Add leading 0 (zero) to month number in power BI

You can use the FORMAT function for this: Expiry_MonthYear_Sorter = ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,770 points
3,354 views
0 votes
1 answer

How to connect Github with power BI?

There are few steps which we need ...READ MORE

Nov 19, 2020 in Power BI by Gitika
• 65,770 points
1,514 views
0 votes
1 answer

Power BI Visualization

Power BI supports R integration for data ...READ MORE

Dec 7, 2020 in Power BI by Gitika
• 65,770 points
690 views
0 votes
1 answer

Direct Query Report gateway connection error

There can be many reasons for this ...READ MORE

Nov 19, 2020 in Power BI by Gitika
• 65,770 points
1,465 views
0 votes
1 answer

Error refreshing dataset with direct query using on-premise gateway connection

What is your data source type? Could ...READ MORE

Nov 19, 2020 in Power BI by anonymous
• 65,770 points
1,394 views
0 votes
1 answer

Unable to Connect to import or direct query reports

Check your cached data sources. Once in ...READ MORE

Nov 20, 2020 in Power BI by Gitika
• 65,770 points
1,256 views
0 votes
1 answer

Error: We couldn't find any data in your Excel workbook

To import from Excel into the Power ...READ MORE

Oct 22, 2020 in Power BI by Gitika
• 65,770 points
2,370 views
0 votes
1 answer

Display data points below chart when bar is selected.

You can use a matrix visual just ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
1,461 views
0 votes
1 answer

DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,770 points
3,262 views
0 votes
1 answer

How to connect webpage data by using Power BI Desktop?

Web connections are only established using basic ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
1,148 views
0 votes
1 answer

How can You Change the Value Measure to Show Multiple Measures Dynamically?

You can dynamically change and switch functions ...READ MORE

Oct 20, 2020 in Power BI by Gitika
• 65,770 points
2,382 views
0 votes
1 answer

How to connect a dataset to a SQL Server database?

In Power BI Desktop, you connected directly ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
1,062 views
0 votes
1 answer

Custom Slicer with two calendar date pickers and custom periods?

This exact look and feel are not ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
1,310 views