Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
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
Hi @shubhamgoswami ,
Please kindly refer to the official article:
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.