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,420 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,060 points • 4,393 views
0 votes
1 answer

Time Series Chart in Power BI

Your Date format should be handled by ...READ MORE

Nov 26, 2018 in Power BI by Upasana
 • 8,620 points • 4,368 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,306 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,890 points • 4,180 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 • 4,165 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,420 points • 4,136 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,890 points • 4,107 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 • 4,096 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,972 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,890 points • 3,948 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,890 points • 3,928 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,890 points • 3,867 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,761 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,890 points • 3,734 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,420 points • 3,575 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,568 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,514 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,497 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,447 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,890 points • 3,436 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,890 points • 3,428 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,890 points • 3,424 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,397 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,890 points • 3,373 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,420 points • 3,325 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,890 points • 3,316 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,890 points • 3,226 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,179 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,890 points • 3,177 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,420 points • 3,138 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 • 3,114 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 • 3,106 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,890 points • 3,089 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 • 3,066 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 • 3,055 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 • 3,024 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,250 points • 2,979 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,977 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,906 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,890 points • 2,899 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,890 points • 2,872 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,871 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,890 points • 2,794 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,793 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,890 points • 2,778 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,777 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,760 views
0 votes
1 answer

How to Get Power BI Embedded Report's Filters' Options

The getFilters function returns the current filters ...READ MORE

Feb 22, 2022 in Power BI by surbhi
 • 3,820 points • 2,680 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,669 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.