Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jespersandren
Frequent Visitor

Power BI Desktop Visuals slow load

Hi,

 

First of all, Im new to Power BI and don't know alot. My issue is that the visuals im using is taking a long time to load, everywhere from 3-30 seconds. I have googled alot and made some smaller changes like unchecked Allow data preview to download in the background, tried to delete unused columns but nothing seems to work and i know for a fact that my pbix isnt big.

 

I have 2-4 tables for now with data and i use the KPI visual with measures to visualize what i need. 

What am i doing wrong, is it the measures (i use Filter function a number of times)?

 

Best regards

1 ACCEPTED SOLUTION
Anonymous
Not applicable

You can use DAX Studio to run traces against your measures in your data model to find the issue

https://daxstudio.codeplex.com/

 

See this blog as a start point of how to use this feature

http://sqlblog.com/blogs/marco_russo/archive/2016/11/01/new-server-timings-features-in-dax-studio-2-...

 

Quite often slow queries often relate to poorly written measures (I used to struggle with this a lot when I first started using Power BI).

Use this tool to investigate what measure is causing you issues and maybe post that query on here if you can't work out how to make the query more efficient after some googling. 

 

 

 

View solution in original post

4 REPLIES 4
Jespersandren
Frequent Visitor

Okey, let me try to explain more in detail how my pbix is set up.

I have 8 tables with different information, each tables has unique information regarding a system or department and i have one table which is only used for Dates and one table used for company goals.

 

I have 26 visuals, all of them are the same visuals ( KPI Indicator visual) and on each of the visuals is a measure connected that i use to filter out the specific information i need, reference/value from table company goals and date. I have 26 measures, one for each KPI.

For example i have a KPI for inspections and to this KPI visual i have a measure (see below), Date and company goal for this specific KPI and all the visuals are set up the same as described above, one measure, one value/reference to Date table and one reference/value to company goals table.

 

M_Safetycritical = CALCULATE(AVERAGE(Operations_Actuals[Safteycriticalinspections%]);FILTER(ALLselected(Operations_Actuals);Operations_Actuals[Datum] <= MAX(Operations_Actuals[Datum]) && Operations_Actuals[Datum] <= today()))

 

But with this set up my pbix is really slow, it takes around 10 seconds to load all of them.

 

Hi @Jespersandren,

 

1. Please make sure one table enabled with "Enable Load" feature each time. Check which table query spend more time. 

q5.PNG

 

2. Also you can take a look at this blog:  http://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up 

3. Try to run the latest Power BI desktop version: https://www.microsoft.com/en-us/download/details.aspx?id=45331. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Would need to know a lot more about your situation to answer see this post: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

You can use DAX Studio to run traces against your measures in your data model to find the issue

https://daxstudio.codeplex.com/

 

See this blog as a start point of how to use this feature

http://sqlblog.com/blogs/marco_russo/archive/2016/11/01/new-server-timings-features-in-dax-studio-2-...

 

Quite often slow queries often relate to poorly written measures (I used to struggle with this a lot when I first started using Power BI).

Use this tool to investigate what measure is causing you issues and maybe post that query on here if you can't work out how to make the query more efficient after some googling. 

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.