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
848 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
413 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
483 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
476 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,101 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,054 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,238 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,363 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,084 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
484 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,582 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,274 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,568 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
763 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,319 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,139 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,635 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,366 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,225 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
152,462 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,690 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,262 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,060 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,521 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
699 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,706 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,176 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,513 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
626 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,768 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,823 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,635 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
532 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,630 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,421 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
674 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
466 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
512 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,415 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
4,976 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
1,973 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,783 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
606 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
425 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
556 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,112 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,000 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
798 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,289 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
619 views