Most viewed questions in Power BI

0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

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

edited May 17, 2019 by Omkar 7,411 views
0 votes
1 answer

Power BI : npgsql installation

As a general rule Npgsql can be ...READ MORE

Nov 27, 2018 in Power BI by Shubham
• 13,490 points
7,407 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

Oct 22, 2018 in Power BI by Hannah
• 18,540 points
7,321 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,890 points
7,318 views
0 votes
1 answer
0 votes
1 answer

How can I use Power BI on my Ubuntu machine

Hey, @Jublleevdsl, Based on my research, currently, it ...READ MORE

Nov 23, 2020 in Power BI by Gitika
• 65,890 points
7,066 views
0 votes
1 answer

Calculating MoM Variance of a Measure Field using DAX

Create an intermediate calculated column that considers ...READ MORE

Feb 28, 2019 in Power BI by Shubham
• 13,490 points
7,057 views
0 votes
1 answer

How to add image in Power BI Report?

Follow the below steps: Create a column with ...READ MORE

Oct 31, 2019 in Power BI by Cherukuri
• 33,030 points
6,989 views
0 votes
1 answer

all and allExcept - DAX functions

Hi Satish, All function is used when you ...READ MORE

May 7, 2019 in Power BI by Cherukuri
• 33,030 points
6,752 views
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,890 points
6,721 views
0 votes
1 answer

Difference between Power Bi Desktop and Power BI Service

Power BI Desktop is a robust resource for data analysis and reporting. It performs all reports, modelling using ...READ MORE

Oct 29, 2019 in Power BI by ch
• 3,450 points
6,675 views
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

Oct 22, 2018 in Power BI by Annie97
• 2,160 points
6,591 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

Aug 23, 2019 in Power BI by anonymous
• 33,030 points
6,518 views
0 votes
1 answer

How to Convert measure to calculated column?

Hi, I have created a new measure using ...READ MORE

Jul 18, 2019 in Power BI by Avantika
• 1,520 points
6,218 views
0 votes
1 answer

Power BI Using SQL Server stored procedures

NOTE: The following works for the "Import ...READ MORE

Dec 14, 2018 in Power BI by Upasana
• 8,620 points
6,214 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
6,163 views
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,890 points
6,156 views
0 votes
1 answer

To expand all lists in a row of lists at the same time without recurring values

Can't promise simple, but I have something ...READ MORE

Feb 19, 2019 in Power BI by Upasana
• 8,620 points
6,031 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

Feb 14, 2019 in Power BI by Upasana
• 8,620 points
6,007 views
+2 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

Oct 3, 2018 in Power BI by Nilesh
• 7,060 points
5,976 views
+1 vote
1 answer

Power BI: TopN and All Other

Hi , Create a measure to calculate rank ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 33,030 points
5,947 views
0 votes
1 answer

Datediff with column having no value/ blank

Hi Karthick, Use the below DAX code - ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
5,924 views
0 votes
1 answer

How to calculate average percentage in Power BI?

You can add one more measure to ...READ MORE

Feb 23, 2022 in Power BI by CoolCoder
• 4,420 points
5,921 views
0 votes
1 answer

By default, which level of filter behaves as same as a slicer in a report in Power BI desktop?

Hey, There are several types of filters in ...READ MORE

Jan 31, 2020 in Power BI by Rakesh
5,740 views
0 votes
1 answer

DAX : Occurrences of "count"

Try this for creating a calculated column ...READ MORE

Nov 22, 2018 in Power BI by Upasana
• 8,620 points
5,616 views
0 votes
1 answer

Call endpoint from Kubernetes Cron Job

CronJobs are a good choice. Here's a ...READ MORE

Sep 27, 2018 in Power BI by Kalgi
• 52,360 points
5,576 views
0 votes
1 answer

Looping in Power Query

In Power Query, you often find a ...READ MORE

Jan 30, 2019 in Power BI by Upasana
• 8,620 points
5,359 views
0 votes
1 answer

Row Level Security not applied through LOOKUPVALUE in Default filter [closed]

I see what you mean now. LOOKUPVALUE appears to ...READ MORE

Nov 8, 2018 in Power BI by Upasana
• 8,620 points
5,332 views
0 votes
1 answer

Multiple slicer using same field

Hi Anitha, You can use the same filed ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
5,255 views
0 votes
2 answers

Can I get rid of the grey border on the report visuals with power bi embedded?

It's just a simple css code to ...READ MORE

Apr 19, 2020 in Power BI by Prateek Mehta
5,183 views
0 votes
1 answer

Power BI (DAX): Distinct Count Filtered by Condition

You can go with this: DistinctCountActiveMonths = CALCULATE( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,890 points
5,171 views
0 votes
1 answer

Scraping Data from a website which uses Power BI - retrieving data from Power BI on a website

Putting the scroll part and the JSON ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,890 points
5,133 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,890 points

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

Power BI not able to connect to Azure SQL with private end point

You'll need to install an on-prem gateway ...READ MORE

Feb 17, 2022 in Power BI by CoolCoder
• 4,420 points
5,035 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

Mar 9, 2019 in Power BI by Avantika
• 1,520 points

edited Mar 9, 2019 by Avantika 4,984 views
0 votes
1 answer

What is query editor in Power BI?

Hi, Power BI Desktop also comes with Power ...READ MORE

Feb 4, 2020 in Power BI by Rishikesh
4,941 views
0 votes
1 answer

Embedding a dashboard using Java in Power BI

Make sure to use the correct embedURL, ...READ MORE

Nov 30, 2018 in Power BI by Shubham
• 13,490 points
4,929 views
0 votes
1 answer

Passing a parameter to Power BI Embedded via embedded URL

Add the following to the end of ...READ MORE

Oct 23, 2018 in Power BI by Annie97
• 2,160 points
4,893 views
+1 vote
1 answer

getting client-credentials access token to authorize Power BI

Try and make sure that the app ...READ MORE

Oct 17, 2018 in Power BI by Annie97
• 2,160 points
4,888 views
0 votes
1 answer

How do I convert month format in Power BI?

Hi, This can easily be done using DAX ...READ MORE

Mar 27, 2019 in Power BI by Avantika
• 1,520 points
4,886 views
+1 vote
2 answers

403 error thrown by power bi report server when trying to get list of data sets

Hey @saranya, Try removing the header and ...READ MORE

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

Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,890 points
4,837 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

Dec 22, 2020 in Power BI by Gitika
• 65,890 points
4,802 views
0 votes
1 answer

How to create Pivot Tables in Power BI?

Hey, First of all, there is no "Pivot ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,890 points
4,698 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
• 33,030 points
4,606 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,890 points
4,593 views
0 votes
1 answer

How can I search for multiple strings?

A simple solution is this: List.ContainsAny(Text.SplitAny("This is a test ...READ MORE

Oct 24, 2018 in Power BI by Upasana
• 160 points
4,589 views
0 votes
3 answers

How do I get token using javascript API while trying to embed graphs using Power BI

Use ADAL.js that will give you an ...READ MORE

Jun 22, 2019 in Power BI by anonymous
4,491 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,890 points
4,469 views