Most viewed questions in Power BI

0 votes
1 answer

Using Treemap as a filter

What you want is possible using the ...READ MORE

Dec 17, 2018 in Power BI by Shubham
• 13,490 points
4,238 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,910 points
4,224 views
0 votes
2 answers

DataFormat.Error Power BI Desktop

The invalid escape sequence is caused by ...READ MORE

Sep 25, 2018 in Power BI by Nilesh
• 7,050 points
4,210 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

Mar 1, 2019 in Power BI by Cherukuri
• 33,030 points
4,147 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,910 points
3,973 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,962 views
0 votes
1 answer

How to convert eight digit yyyymmdd to date using DAX in Power BI ?

You can go through this: column = IFERROR( ...READ MORE

Dec 8, 2020 in Power BI by Gitika
• 65,910 points
3,874 views
0 votes
1 answer

How to customize the report for different users in power BI?

There are different ways to achieve this. 1. ...READ MORE

Oct 30, 2019 in Power BI by Cherukuri
• 33,030 points
3,867 views
0 votes
1 answer

Power BI - how to authenticate to app.powerbi.com silently

 I have to create the application in ...READ MORE

Feb 21, 2022 in Power BI by CoolCoder
• 4,400 points
3,761 views
0 votes
1 answer

dax calculation for last N days

Hi, @Vnk, Regarding your above query, you can ...READ MORE

Jun 30, 2020 in Power BI by Gitika
• 65,910 points
3,760 views
+1 vote
1 answer

How to resolve Power BI DAX Join error?

Sample Table Used Here: Table1: Partner_ID, User_Id Table2: User_Id, ...READ MORE

May 15, 2019 in Power BI by Avantika
• 1,520 points

edited May 15, 2019 by Omkar 3,670 views
0 votes
1 answer

Embed URL-multiple filters in Power BI

With the release of 2.0.0 you can ...READ MORE

Oct 16, 2018 in Power BI by Annie97
• 2,160 points
3,608 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,910 points
3,581 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,910 points
3,553 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,910 points
3,547 views
0 votes
1 answer

How to use Python Scripts in Query Editor?

Hi, In order to use Python Visuals you need ...READ MORE

Apr 11, 2019 in Power BI by Avantika
• 1,520 points
3,412 views
0 votes
1 answer

Spell check in Power BI

Simply navigate to another page and return ...READ MORE

Feb 14, 2022 in Power BI by CoolCoder
• 4,400 points
3,385 views
0 votes
1 answer

Select Columns from table instead of removing afterwards in Power Query

Try this. let db = Sql.Databases("sqlserver.database.url"){[Name="DatabaseName"]}[Data], Sales_vDimCustomer = ...READ MORE

Oct 31, 2018 in Power BI by Shubham
• 13,490 points
3,327 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,323 views
0 votes
1 answer

Pivot table drill down functionality in Power BI

There is a clear deficit in the ...READ MORE

Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,278 views
0 votes
1 answer

last 10 days data based on Date&time

Hi, @Vnk, Regarding your query, you have to ...READ MORE

Jun 4, 2020 in Power BI by Gitika
• 65,910 points
3,238 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,910 points
3,230 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,910 points
3,227 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,910 points
3,160 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

May 10, 2019 in Power BI by anonymous
• 33,030 points
3,086 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,910 points
3,061 views
0 votes
1 answer

Connecting POWER BI web with AWS mysql database

So, there's no direct way to connect ...READ MORE

Nov 9, 2018 in Power BI by Shubham
• 13,490 points
3,060 views
0 votes
1 answer

Power BI: Giving users the option to include or exclude a type of data

The best option, in my opinion, is ...READ MORE

Feb 18, 2022 in Power BI by CoolCoder
• 4,400 points
3,040 views
+2 votes
1 answer

how to split country & city in Dax power bi

After loading the dataset, you can split ...READ MORE

Nov 25, 2020 in Power BI by Gitika
• 65,910 points
3,022 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,910 points
3,013 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,910 points
2,944 views
0 votes
1 answer

Locating closest match based on Latitude & Longitude

First of all, we need to use the ...READ MORE

Jan 2, 2019 in Power BI by Shubham
• 13,490 points
2,927 views
0 votes
1 answer

How can I concatenate grouped values in PowerQuery ?

If your table is Source, and if ...READ MORE

Feb 27, 2019 in Power BI by Shubham
• 13,490 points
2,923 views
0 votes
1 answer

Power BI On-Premises Data Gateway through a VM for customers?

There isn't any other choice, To connect ...READ MORE

Feb 21, 2022 in Power BI by CoolCoder
• 4,400 points
2,868 views
0 votes
1 answer

Applying multiple filters in PBI Embed URL

Well, that is actually a limitation in ...READ MORE

Aug 21, 2018 in Power BI by DataKing99
• 8,240 points
2,852 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

Oct 18, 2019 in Power BI by anonymous
• 3,450 points
2,819 views
0 votes
1 answer

Power BI DAX expression more than 2 or conditon

Heyyy @Hannah, you just need remove or ([principlecode] = ...READ MORE

Oct 29, 2018 in Power BI by Kalgi
• 52,360 points
2,799 views
0 votes
1 answer

Cumulative row data over last 12 months in Power Query

Basically, what you do is,  Add an Index,  Group ...READ MORE

Apr 1, 2019 in Power BI by Upasana
• 8,620 points
2,793 views
0 votes
1 answer

Acquire access token from Azure AD for native app registration (PowerBI) using client credentials

AFAIK , Power BI REST API only ...READ MORE

Nov 12, 2018 in Power BI by Upasana
• 8,620 points
2,774 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,910 points
2,755 views
+1 vote
3 answers

Difference between Power BI pro and Power BI Premium

My answer is applicable for a company ...READ MORE

Oct 30, 2018 in Power BI by chiranjeevi
• 160 points
2,714 views
0 votes
1 answer

How to parse a .json column in Power BI?

Use Json.Document function like this let ...READ MORE

Dec 21, 2020 in Power BI by Gitika
• 65,910 points
2,692 views
0 votes
1 answer

Shared datasets in Power BI

Follow the below steps to create shared ...READ MORE

Oct 29, 2019 in Power BI by Cherukuri
• 33,030 points
2,685 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
2,658 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,910 points
2,596 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,910 points
2,586 views
0 votes
1 answer

Power Query: Split Column by field lengths

Start by creating a query with the ...READ MORE

Jan 30, 2019 in Power BI by Upasana
• 8,620 points
2,561 views
0 votes
0 answers

How to work on existing power query using python

Hi I have an existing power query created ...READ MORE

Feb 7, 2020 in Power BI by Biswajith
• 120 points
2,560 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,539 views
0 votes
0 answers

DataSource.Error: ADO.NET: R script error. Error in is.data.frame(x) : object 'ALL_Data' not found

I am trying to export data from ...READ MORE

Feb 14, 2020 in Power BI by ankita
• 120 points
2,522 views