Forum Discussion

niyati_61's avatar
niyati_61
Icon for Helper III rankHelper III
4 years ago

PBI Report - Very slow performance

Hi d_gosbell,   My Power BI Report has become very slow. When I open my report, in context of charts, they take too long to appear.  And pages where I've buttons (bookmarks) to switch between char...
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

niyati_61 , first of all, automate data loading using on-premise gateway. replace excel in the folder and power bi service should take it up.

Reason can be

1. DAX - Measures - You need to test them using performance analyzer and DAX studio

2. Too many visual on page

3. Custom visual may also slow down

 

This is going to be step by step approach ruling out what is working and  not working.

 

Remove all columns and measure, not in use.

If the report can be split into multiple reports then do that