On our P1 Premium environment, after a large dataset is refreshed overnight, the first person to load a report sees a long wait (5-10 minutes) before any visuals/data are displayed.
Following this, as the dataset is now "in memory", all reports load very quickly as expected.
Is there any way we can speed up this initial load into memory - or even program the load via XMLA endpoints, etc?
I personally found 'dataflow' significantly improved my processing time as the data transformation and refreshment is performed in Cloud. I am wondering if you have used it?
Thanks for the response - however it is not the report that is slow - it is the initial load of the dataset into Premium memory that is slow. Once this has been completed the report loads fine and reacts quickly. It is simply the first time that someone interacts with the report after a refresh.
We cannot debug this in Power BI Desktop as this connects to the live dataset and experiences the same issues - a 5 minute wait for the dataset to load into memory, and then the report loads quickly.
Does that make sense?
Because the first load is the slow one, that's the main reason for a slow report. The performance analyzer, as the video show, will be use to check the first load of the pages because the second one will be in cache (so it will be fast even if the report contains bad practises).
Please check the video. It sounds like you have heavy dax or visualizations. You can also be loading innecesary columns or having a problem in modeling.
I think you're getting mixed up - the first load of a report is not the slow thing, it's the first load of ANY report connected to the shared dataset after a refresh - after the dataset has been evicted from memory.
For example I have a completely blank report with one field in, connected to the dataset (i.e. no DAX at all) and even that takes 5 minutes to load after the dataset has been refreshed.
No DAX, No Visualisations, no columns being loaded...just to get the DATASET to even load into memory.
I'm having the same issue. When we refresh a heavy dataset it takes about 5 minutes just to load an embedded report, even if it's a simple report with just one table. Subsecuent loads works just fine, but since we refresh this every 30 minutes the issue is constant. Did you find any workaround?
We're using embedded Gen 1, would Gen 2 help to solve this issue?
Yes, this is already enabled with no difference in outcome.
the dataset has been evicted from premium memory and so the wait time is while it is getting loaded back in - is there any way we can either keep it in memory, or programmatically preload the dataset once the refresh has completed?
Same here. My report uses DirectQuery only and has long initial load times both on Power BI Report Server and Power BI Service. So it can't be related due to Power BI Gateway issues. Opening it in Power BI Desktop is fast.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!