Trending questions in Power BI

0 votes
1 answer

How to connect a dataset to a SQL Server database?

In Power BI Desktop, you connected directly ...READ MORE

Nov 18, 2020 in Power BI by Gitika
• 65,770 points
1,078 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,315 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
1,044 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,300 views
0 votes
1 answer

Solving an error in my report query.

This situation typically happens when you have ...READ MORE

Nov 20, 2020 in Power BI by Gitika
• 65,770 points
851 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,156 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
945 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
906 views
0 votes
1 answer

How to calculate average inventory in power bi?

Hi @There, Is there any index field in ...READ MORE

Sep 28, 2020 in Power BI by Gitika
• 65,770 points
2,931 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
1,011 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
999 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,797 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
842 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
872 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,617 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
742 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,210 views
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,181 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
619 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

Feb 6, 2020 in Power BI by Gitika
• 65,770 points
12,574 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,162 views
0 votes
1 answer

How to find out what all datasets are currently running without manually seeing the each dataset refresh history in PowerBI

Go to ur workspace, click on dataset ...READ MORE

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

Recursive logic in DAX

Hey,  The only option is to break down ...READ MORE

Sep 28, 2020 in Power BI by Gitika
• 65,770 points
2,366 views
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,770 points
1,892 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
26,893 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

Create a new measure for the km ...READ MORE

Oct 5, 2020 in Power BI by Gitika
• 65,770 points
1,967 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
935 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,229 views
0 votes
1 answer

DAX formula to concatenate three columns.

If the columns are already text, you ...READ MORE

Oct 1, 2020 in Power BI by Gitika
• 65,770 points
1,989 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
1,078 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
806 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,770 points
744 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
770 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
850 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,579 views
0 votes
1 answer

What is the difference between PowerPivot, Power Query and Power BI?

Power Query Power Query is a self-service ETL ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,770 points
2,167 views
0 votes
1 answer

DAX / PowerPivot query functions to spread aggregated values over time period

The solution below assumes a table called ...READ MORE

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

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,770 points
2,031 views
0 votes
1 answer

DAX Userelationship function

 You need a way for the measure ...READ MORE

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

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

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

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

Sep 24, 2020 in Power BI by Gitika
• 65,770 points
1,834 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
669 views
0 votes
1 answer

How do I use the DAX function ParallelPeriod?

The DAX expression you used in the ...READ MORE

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

How do I get my DAX measure to calculate grouped values?

Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE

Oct 8, 2020 in Power BI by Gitika
• 65,770 points
846 views
0 votes
1 answer

DAX function to create LY Measure without date dimension

It should be fairly simple (sumx of ...READ MORE

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

Error: the column 'People[FullName]' either doesn't exist or doesn't have a relationship to any table available in the current context.

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

Sep 28, 2020 in Power BI by Gitika
• 65,770 points
1,199 views
0 votes
1 answer

Recursion in DAX

You can check this out:  DECLARE @myTable as ...READ MORE

Sep 28, 2020 in Power BI by Gitika
• 65,770 points
1,079 views
+1 vote
1 answer

Topic -Power BI Paginated Reports with Excel or CSV file data source

Hi, @There, With Power BI Desktop, you can ...READ MORE

Aug 28, 2020 in Power BI by Carlos
2,335 views