Performance issue with customized visual plots

[shubhamgoswami]

Hi,

I have created a dashboard with custom visual python plots with 5 slicers/filters. Now both desktop and report are taking lots of tiime to load with every filter change (30sec to 1min) for each plots.

I have optimized all the codes to basic level ( removed all the power querry and loops in the code) but still facing the same issue.

Suggestions will be much appreciated.

Thanks alot in advance.

Shabham 

[v-diye-msft]

Hi @shubhamgoswami ,

1. Quite often slow queries often relate to poorly written measures. 

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

https://daxstudio.codeplex.com/

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. 

[shubhamgoswami]

Hi @v-diye-msft 

Thanks a lot for your suggestions.

I have already tried all th above options but still I am facing the same issue.

Not only the report file, even PBI desktop is also taking lots of time to load.

Your help would be much appreciable.

Shubham

[v-diye-msft]

Hi @shubhamgoswami ,

Please kindly refer to the official article:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#understand-custom-visual-perf...

For a deeper dive into which visuals are taking up the most time and resources, you can connect SQL Profiler to Power BI Desktop to get all full view of query performance.