Latest questions in Power BI

0 votes
1 answer

Power BI - Amazon RedShift

Hi,  Follow these steps, to connect to Amazon ...READ MORE

Mar 25, 2019 in Power BI by Cherukuri
• 33,030 points
863 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
425 views
0 votes
1 answer

Power BI - Azure SQL Warehouse

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

Mar 25, 2019 in Power BI by Cherukuri
• 33,030 points
501 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
485 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
1,109 views
+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

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

How to connect to IBM DB2 database from power Bi?

Hi, Hi, Follow these steps, to connect to IBM ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
11,309 views
+1 vote
3 answers

How to connect to oracle database from power Bi?

I use Devart ODBC drivers in order ...READ MORE

Dec 20, 2019 in Power BI by Tony
• 160 points
29,461 views
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
7,129 views
0 votes
1 answer

Append excel data and In house database data that gets refresh evey 24 hour

Hi, You can try this way, A  -  Actual ...READ MORE

Mar 20, 2019 in Power BI by Sindhu
513 views
0 votes
1 answer

How can I get a column value from previous row in Power Query?

Hi Sindhu, add this line as your ...READ MORE

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

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

Mar 18, 2019 in Power BI by Cherukuri
• 33,030 points
18,355 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,607 views
0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
795 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

Dec 16, 2020 in Power BI by Roshni
• 10,520 points
69,958 views
0 votes
1 answer

Calculated column with the sum of values from many columns in a row

Hi, You can create a new column by ...READ MORE

Mar 14, 2019 in Power BI by Cherukuri
• 33,030 points
2,187 views
0 votes
1 answer

Count occurrences in DAX

You can use DAX functions to do ...READ MORE

Mar 9, 2019 in Power BI by Avantika
• 1,520 points
25,697 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,426 views
0 votes
1 answer

Combining field values to create an additional field?

Hi Nithin, 1. Go to Power Query Editor, ...READ MORE

Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
1,286 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
153,333 views
0 votes
1 answer

How do you embed dashboard using JavaScript in Power BI?

Dashboards in Power BI can be embedded ...READ MORE

Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
1,727 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
1,275 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,082 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

Dec 16, 2020 in Power BI by Gitika
• 65,910 points
53,797 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

Feb 28, 2019 in Power BI by Cherukuri
• 33,030 points
731 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
6,741 views
0 votes
1 answer

Calculate Total number of Male & Female in the PowerBI report

To achieve what you are looking for, ...READ MORE

Feb 28, 2019 in Power BI by Upasana
• 8,620 points
10,283 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,550 views
0 votes
1 answer

How do you create visualizations in Power BI?

Visualizations in Power BI Visuals are the end-result ...READ MORE

Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
651 views
0 votes
1 answer

PowerQuery : How can I reference a cell's value?

You can do so using a named ...READ MORE

Feb 27, 2019 in Power BI by Shubham
• 13,490 points
18,845 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,843 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
5,707 views
0 votes
1 answer

Replace “yes” found in one list with the actual string from another list

Objective : The idea is to use List.Transform twice, ...READ MORE

Feb 19, 2019 in Power BI by Upasana
• 8,620 points
547 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
5,659 views
0 votes
1 answer

Power Query : Adding Columns and Multiple files

The following call, FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) shall replace the ...READ MORE

Feb 14, 2019 in Power BI by Upasana
• 8,620 points
1,442 views
0 votes
2 answers

Using R packages in Power BI

You can use the powerful R programming language to ...READ MORE

Feb 8, 2019 in Power BI by rajesh
• 1,270 points
685 views
0 votes
1 answer

Bar chart : Arranging in descending order using data from another chart

Select treemap.  Make it active.  Turn on Visual Interactions ...READ MORE

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

Power BI Service : System.Object type is not supported

You have to modify the stream analytics ...READ MORE

Feb 7, 2019 in Power BI by Shubham
• 13,490 points
532 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,445 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,023 views
0 votes
2 answers

Power BI : Case Sensitivity

Oracle DB specific workaround, For Dimension & Fact ...READ MORE

Apr 26, 2019 in Power BI by Mahendra
2,002 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,819 views
0 votes
1 answer

.Net Core 1.1 : Power BI Embedded

Hope this might be of some help ...READ MORE

Dec 27, 2018 in Power BI by Upasana
• 8,620 points
617 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
435 views
0 votes
1 answer

Using R packages in Power BI

When you're trying to use R on ...READ MORE

Dec 17, 2018 in Power BI by Shubham
• 13,490 points
564 views
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,143 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,021 views
0 votes
1 answer

Power BI Desktop : Npgsql 3.0.3 error

You can fix this issue by installing the ...READ MORE

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

Power Query : http POST request with form data

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

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

Power Query: Custom Columns

This call: FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) replaces the column names ...READ MORE

Dec 12, 2018 in Power BI by Upasana
• 8,620 points
641 views