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).
Advocate ISome 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).