Latest questions in Power BI

0 votes
1 answer

How to create and publish a Power BI Desktop file?

Use the following procedure to create a ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
868 views
0 votes
1 answer

How to connect webpage data by using Power BI Desktop?

Web connections are only established using basic ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
1,005 views
0 votes
1 answer

How to connect to data in Power BI Desktop

With Power BI Desktop, you can connect ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
904 views
0 votes
1 answer

PowerPivot DAX - Dynamic Ranking Per Group (Min Per Group)

Firstly create a basic measure [Amount] to sum the ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
1,832 views
0 votes
1 answer

Cumulative distinct count filtered by last value - DAX

MyFilteredCumulativeMeasure = COUNTROWS( FILTER( ...READ MORE

Nov 18, 2020 in Power BI by anonymous
• 65,770 points
2,082 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,770 points
5,340 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,770 points
4,949 views
0 votes
1 answer

Direct Query Cannot Load Model. Login Failed for user. The exception was by raised by the IDbConnect

The current power bi pbix file connection ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
2,453 views
0 votes
1 answer

Several errors occurred during data refresh.

"Connexion successful" mean "the network connection is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
1,989 views
0 votes
1 answer

Queries Metadata Loading data into Model... Fail

In the DirectQuery mode, no data is ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
813 views
0 votes
1 answer

Error Error on Data load when open report in server "An error has occurred"

The problem you can solve by edit this ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
1,561 views
0 votes
1 answer

Error occurred. Unable to load drag and drop problem.

You can solve this by logging in to ...READ MORE

Nov 16, 2020 in Power BI by Gitika
• 65,770 points
818 views
0 votes
1 answer

How to enable left join with mysql group_concat csv merged instances of right side column values.

You can look for this:   let ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
711 views
0 votes
1 answer

Display data points below chart when bar is selected.

You can use a matrix visual just ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
1,351 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,770 points
2,997 views
0 votes
1 answer

Custom Slicer with two calendar date pickers and custom periods?

This exact look and feel are not ...READ MORE

Nov 12, 2020 in Power BI by Gitika
• 65,770 points
1,208 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,770 points
3,464 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,770 points
656 views
0 votes
0 answers

Error: The name provided is not properly formed account name.

Today I try to create a new ...READ MORE

Nov 12, 2020 in Power BI by Roshni
• 10,480 points
1,012 views
0 votes
1 answer

R scripts for Importing Data in powerBI?

There may be times when you don’t ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,770 points
1,193 views
0 votes
1 answer

How to verify that R and R studio are installed on your system?

To verify that R and R studio ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,770 points
523 views
0 votes
1 answer

How to integrate python with power BI?

Python is often used for data visualization ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,770 points
758 views
0 votes
1 answer

How to integrate R with PowerBI?

Including Python and R in Power BI ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,770 points
805 views
0 votes
1 answer

How to install and setup power BI?

Installation and Set up Listed below are a ...READ MORE

Nov 11, 2020 in Power BI by Gitika
• 65,770 points
862 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,770 points
2,895 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,770 points
4,286 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,770 points
3,608 views
0 votes
1 answer

Is it possible to use multiple dataset for one report?

Yes, of course, you can load a few ...READ MORE

Oct 29, 2020 in Power BI by Gitika
• 65,770 points
2,396 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,770 points
721 views
0 votes
1 answer

How to change import mode to direct mode of connection in powerBI

Create a new file connect in import ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,770 points
1,073 views
0 votes
1 answer
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,770 points
658 views
0 votes
1 answer
0 votes
1 answer

How to convert date format in PowerBI?

Change the column data type in excel ...READ MORE

Oct 29, 2020 in Power BI by anonymous
• 65,770 points
1,094 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

Oct 27, 2020 in Power BI by Gitika
• 65,770 points
1,041 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,770 points
659 views
0 votes
1 answer

How to connect to data with PowerBI desktop?

With Power BI Desktop, you can connect ...READ MORE

Oct 27, 2020 in Power BI by Rajiv
• 8,870 points
700 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,770 points
693 views
0 votes
2 answers

Transform a heavy calculated measure (accumulated) into a column in Power BI

Hello, @Marinafr, If you are using Pro License ...READ MORE

Oct 23, 2020 in Power BI by Rajiv
• 8,870 points
1,379 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,770 points
3,521 views
0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

Oct 22, 2020 in Power BI by anonymous
• 65,770 points
1,685 views
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,770 points
808 views
0 votes
1 answer

Error: We couldn't find any data in your Excel workbook

To import from Excel into the Power ...READ MORE

Oct 22, 2020 in Power BI by Gitika
• 65,770 points
2,069 views
0 votes
1 answer

How do you Hide and Unhide a Specific Report in Power BI?

In the menu bar, choose the Selection ...READ MORE

Oct 20, 2020 in Power BI by Gitika
• 65,770 points
10,671 views
0 votes
1 answer

How can You Change the Value Measure to Show Multiple Measures Dynamically?

You can dynamically change and switch functions ...READ MORE

Oct 20, 2020 in Power BI by Gitika
• 65,770 points
2,106 views
0 votes
1 answer

How to Toggle Between Two Option and Make it Interact with the rest of the Visualizations in a Report?

Toggling is an action that is achieved ...READ MORE

Oct 20, 2020 in Power BI by anonymous
• 65,770 points
1,111 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,770 points
575 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,770 points
3,180 views
0 votes
1 answer

How to measure as date variable when calculating time periods in Powerpivot?

You were pretty close - the trick ...READ MORE

Oct 8, 2020 in Power BI by Andi Mohor
1,383 views