Trending questions in Power BI

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,850 points
2,538 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
34,142 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,850 points
730 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,850 points
1,497 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,850 points
626 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,850 points
1,464 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,850 points
319 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,850 points
315 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,850 points
265 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,850 points
965 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,850 points
268 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,850 points
1,434 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,850 points

edited Sep 25, 2020 by Gitika 2,627 views
0 votes
1 answer

How to create and publish a Power BI Desktop file?

Use the following procedure to create a ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,850 points
247 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,850 points
343 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,850 points
207 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,850 points
208 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,850 points
448 views
0 votes
1 answer

Solving an error in my report query.

This situation typically happens when you have ...READ MORE

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

How to connect to data in Power BI Desktop

With Power BI Desktop, you can connect ...READ MORE

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

R scripts for Importing Data in powerBI?

There may be times when you don’t ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,850 points
456 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,850 points
1,362 views
0 votes
1 answer

Error occurred. Unable to load drag and drop problem.

You can solve this by logging in to ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,850 points
194 views
0 votes
0 answers

Error: The name provided is not properly formed account name.

Today I try to create a new ...READ MORE

Nov 12, 2020 in Power BI by Roshni
• 10,500 points
368 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,850 points
304 views
0 votes
1 answer

Queries Metadata Loading data into Model... Fail

In the DirectQuery mode, no data is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,850 points
159 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,850 points
1,741 views
0 votes
1 answer

How to install and setup power BI?

Installation and Set up Listed below are a ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,850 points
249 views
0 votes
1 answer

Is it possible to restrict SQL query result visibility by column data using RLS?

RLS is on row level, you can ...READ MORE

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

How to enable left join with mysql group_concat csv merged instances of right side column values.

You can look for this:   let ...READ MORE

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

How to integrate python with power BI?

Python is often used for data visualization ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,850 points
138 views
0 votes
1 answer

How to integrate R with PowerBI?

Including Python and R in Power BI ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,850 points
113 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,850 points
1,574 views
0 votes
1 answer

How to verify that R and R studio are installed on your system?

To verify that R and R studio ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,850 points
95 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,850 points
4,621 views
0 votes
1 answer

How to convert date format in PowerBI?

Change the column data type in excel ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,850 points
481 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,850 points
1,378 views
0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

Oct 22, 2020 in Power BI by anonymous
• 65,850 points
694 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,850 points
723 views
0 votes
1 answer

How to change import mode to direct mode of connection in powerBI

Create a new file connect in import ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,850 points
288 views
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
1,754 views
0 votes
1 answer
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

Oct 27, 2020 in Power BI by Gitika
• 65,850 points
227 views
0 votes
1 answer

How to add a One drive Excel as a Data set in Power BI?

If the one Drive is from your ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,850 points
169 views
0 votes
1 answer

How to analyze the data in Power BI using Excel?

Once you've enabled editing and content, Excel ...READ MORE

Oct 27, 2020 in Power BI by Gitika
• 65,850 points
184 views
0 votes
1 answer

Do we have any auto email functionality in power BI?

You can embed an email link with ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,850 points
101 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,850 points
371 views
0 votes
1 answer

How to connect to data with PowerBI desktop?

With Power BI Desktop, you can connect ...READ MORE

Oct 27, 2020 in Power BI by Rajiv
• 8,910 points
114 views
0 votes
2 answers

Transform a heavy calculated measure (accumulated) into a column in Power BI

Hello, @Marinafr, If you are using Pro License ...READ MORE

Oct 23, 2020 in Power BI by Rajiv
• 8,910 points
228 views