Forum Discussion
Advocate ISlow refresh time in Power BI service
Some update for this issue.
Our main data source is from SSAS with import mode, and we will refresh the data via Enterprise Gateway. We made the following changes and the refresh time was from over 2 hours, which would time out and never got success, to 20 mins by scheduled refresh or 8 mins by manully refresh.
1. upgraded the SSAS server to 4 vcore and 16GM of RAM and use D-series in Azure.
2. moved gateway from prviate cloud to Azure.
Based on the official document, import mode will require more RAM than CPU. However, in our case, the gateway memory always uses around 2~2.5 GB and the CPU is around 80%(4 vcores).
Community SupportHi VL22 ,
According to your description, here is my suggestion.
Your data source is from SSAS and use import mode, which may cause the slow connection. If the source data changes frequently or is large, and the increased load in the source and the impact on query performance are acceptable, consider using DirectQuery/LiveConnect mode instead of import mode. Please change the connection mode, and try again to see if it is still to slow.
Please refer to the following document.
Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IHi v-xiaosun-msft ,
Thank you for your reply. Regarding the frequency of data changes in SSAS, this SSAS only process one time per day and I always refreshed the dataset after the process.
Based on the SQL Profiler's data, for both of the refreshes, I can see the same DAX query was sent to SSAS. If all the query is handling in SSAS, do you have any idea why refreshing in Desktop was much faster than refreshing in Power BI Service? Thank you!
Best regards,
VL