Most viewed questions in Power BI

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,148 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,130 views
0 votes
1 answer

Calculate GB Using DAX in Power BI

Hi, @Vnk You can go through this regarding ...READ MORE

Jun 30, 2020 in Power BI by Gitika
 • 65,910 points • 4,113 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,084 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,870 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,850 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,781 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,720 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,641 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,547 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,546 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,528 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,435 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,388 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,380 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,358 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,256 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,246 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,236 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,174 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,099 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,075 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,073 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,072 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 • 2,970 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 • 2,965 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 • 2,961 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 • 2,932 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 • 2,892 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,875 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,847 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 • 2,844 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,828 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,787 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,722 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,718 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,698 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,682 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,625 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,621 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,596 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,571 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,555 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,549 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,508 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,505 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,501 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,484 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,461 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,453 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.