Power BI Desktop Visuals slow load

[Jespersandren]

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

[Jespersandren]

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.

[v-qiuyu-msft]

Hi @Jespersandren,

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

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 

[Greg_Deckler]

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

[Anonymous · Accepted solution]

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.