Most viewed questions in Power BI

0 votes
1 answer

Import Excel data to power Bi service

There is a  way that is directly ...READ MORE

Oct 22, 2020 in Power BI by Gitika
• 65,910 points
549 views
0 votes
1 answer

Spell check in PowerBI

Use this API service and create a ...READ MORE

Mar 2, 2022 in Power BI by gaurav
• 23,260 points
548 views
0 votes
1 answer

Switch Power BI data sources from Excel to Azure analysis services

One option that you should consider would ...READ MORE

Sep 28, 2018 in Power BI by Kalgi
• 52,360 points
547 views
0 votes
1 answer

Power BI Reporting Server - Portal Administrator Functionality

I think you need to link it ...READ MORE

Sep 25, 2018 in Power BI by Kalgi
• 52,360 points
547 views
0 votes
1 answer

How do you add a new column with the calculated result?

Hi, You can do this with the help ...READ MORE

May 27, 2019 in Power BI by Avantika
• 1,520 points
546 views
0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,570 points
545 views
0 votes
1 answer

Power BI - Salesforce

Hi, Follow below steps: 1. Go to Data source. 2. ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
• 33,030 points
544 views
0 votes
1 answer

Max count of workspaces per one PRO user

Right now, it is 250, will be ...READ MORE

Sep 24, 2018 in Power BI by Hannah
• 18,570 points
543 views
0 votes
1 answer

append a column to another column

Hi Priya, You can use concatenate to join ...READ MORE

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

Power BI Embedded : Importing Packages

This should help you out. https://www.nuget.org/packages/PowerBI.N ...READ MORE

Apr 3, 2019 in Power BI by Shubham
• 13,490 points
540 views
0 votes
1 answer

Autorefresh the Power BI report with import Query

You should publish the report from the ...READ MORE

Feb 10, 2022 in Power BI by CoolCoder
• 4,400 points
537 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,910 points
536 views
0 votes
1 answer

Conditional formatting - Power BI

Hi Chandan, First, create a bar chart as ...READ MORE

Jun 13, 2019 in Power BI by anonymous
• 33,030 points
535 views
0 votes
1 answer

Replace field values if matched

Create a custom column in Power Query ...READ MORE

Oct 31, 2019 in Power BI by anonymous
• 3,450 points
534 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,910 points
532 views
0 votes
0 answers

Create a sample report in power BI using R script

how to create a sample chart using ...READ MORE

Jun 20, 2019 in Power BI by Anitha
531 views
0 votes
0 answers

How to create a custom column for comparing between of 2 numbers?

Hi How do I create a custom ...READ MORE

Jun 28, 2019 in Power BI by Phalguni
• 1,020 points
524 views
0 votes
1 answer

Categorised data in Power BI

Use a helper table to store these ...READ MORE

Feb 8, 2022 in Power BI by CoolCoder
• 4,400 points
516 views
0 votes
1 answer

How do Report server e-mail deliver reports?

Report server e-mail delivery can deliver reports ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,570 points
516 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

Apr 10, 2019 in Power BI by Avantika
• 1,520 points
515 views
0 votes
1 answer

Convert an expression from SQL to Power BI

Use the following expression: MyTemperatureTable = FILTER ( Device1234, ...READ MORE

Oct 22, 2018 in Power BI by Hannah
• 18,570 points
514 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,910 points
511 views
0 votes
1 answer

How to get a regression summary in scikit-learn like R does?

In sklearn, there is no summary report ...READ MORE

Feb 27, 2022 in Power BI by CoolCoder
• 4,400 points
508 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,910 points
508 views
0 votes
1 answer

Power BI integration with R

Follow the below steps: 1. Install R in your ...READ MORE

Jun 21, 2019 in Power BI by Cherukuri
• 33,030 points
507 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10, 2019 in Power BI by anonymous
503 views
0 votes
1 answer

Power Query: Adding a Special Case

Try adding a Group By with Minimum ...READ MORE

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

Format Data to tabular structure in Excel - Power m Query - Excel

Hi, @Kiranbvsn You can check this out: https://www.howtoexcel.org/ ...READ MORE

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

How to Filter a Query?

Hi, You can do the same in Power ...READ MORE

Jun 14, 2019 in Power BI by Avantika
• 1,520 points
499 views
0 votes
1 answer

How do you change the tables in chart filters?

Hi, You can use the following measure. Measure 2 = ...READ MORE

May 10, 2019 in Power BI by Avantika
• 1,520 points
499 views
0 votes
1 answer

Power BI - How to make groups?

hi Nithin, Follow these steps to create groups: 1. ...READ MORE

Mar 26, 2019 in Power BI by Cherukuri
• 33,030 points
499 views
0 votes
0 answers

How to show a color bar even when no value is present or value is 0?

How to show a color bar even ...READ MORE

Jun 13, 2019 in Power BI by Priya
498 views
0 votes
1 answer

Power BI Visualization

Power BI supports R integration for data ...READ MORE

Dec 7, 2020 in Power BI by Gitika
• 65,910 points
497 views
0 votes
1 answer

Power BI : JSON data

Just beside each Record (if headers), are ...READ MORE

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

Difference between the number of days user(client) has logged into the website.

Hi Rajesh, Use below code -  Column 4 = ...READ MORE

May 9, 2019 in Power BI by Cherukuri
• 33,030 points
492 views
0 votes
1 answer

Replace and Round

Hey Anshuli, Create a column as below, Column = ...READ MORE

May 21, 2019 in Power BI by anonymous
• 33,030 points
489 views
0 votes
1 answer

Power BI in use cases

Power is BI is used for gathering ...READ MORE

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

How can I join tables using only DAX?

You can see this below example: FILTER('InternetSales_USD' ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,910 points
480 views
0 votes
1 answer

Power BI - Postgresql

Hi,  Follow these steps, to connect to Postgresql database.  1. ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
• 33,030 points
479 views
+2 votes
0 answers

USE PostgreSQL

Aug 27, 2019 in Power BI by anonymous
473 views
0 votes
1 answer

Difference between Power BI vs Tableau.

Here you go!  Feature Power BI Tableau Data visualization Focuses only on ...READ MORE

Oct 20, 2020 in Power BI by Gitika
• 65,910 points
471 views
0 votes
1 answer

Power bi Reports

Yess! You should look into app.powerbi.com. That’s ...READ MORE

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

Is government, academic and nonprofit pricing available for Power BI?

Yes, nonprofit pricing is available when purchasing ...READ MORE

Sep 26, 2018 in Power BI by Kalgi
• 52,360 points
454 views
0 votes
1 answer

End with characters in column

Hi Rahul, You can use condition such as ...READ MORE

May 21, 2019 in Power BI by anonymous
• 33,030 points
451 views
0 votes
1 answer

Measure to filter date from another field

Hi, Create a column with [date-field].[month] to fetch ...READ MORE

May 17, 2019 in Power BI by Cherukuri
• 33,030 points
446 views
0 votes
1 answer

Excel PowerPivot DAX Calculated Field

You should create a relationship between each ...READ MORE

Oct 5, 2020 in Power BI by Gitika
• 65,910 points
445 views
0 votes
1 answer

Show orders from past n months

Hi banu, Create a column like below, diff = DATEDIFF(Orders[Order ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
• 33,030 points
444 views
0 votes
1 answer

Multi region EC2 & RDS replication from Region A to various other regions

Because of its low latency, RDS is ...READ MORE

Mar 2, 2022 in Power BI by gaurav
• 23,260 points
441 views
0 votes
1 answer

Starts with characters in column

Hi Rahul, You can use condition such as ...READ MORE

May 21, 2019 in Power BI by anonymous
• 33,030 points
429 views