Forum Discussion
Refresh on Service takes longer than Desktop
I've recently made changes to a Power BI model that has significantly slowed down the refresh time. Before the changes discussed below, a typical refresh on both Desktop/Online would take approximate...
v-anabat
Microsoft Employee
Microsoft Employeeeven I have same issue with my report, it takes around only 1min when refresh the desktop file, but in workpsace it's taking around 20mins. Also, all the connections I'm using in the report are Azure.
Please let me know if you have found any answer for this.
- v-anabat
Hi,
I have a Power BI report which takes around 1min to complete the overall refresh when I refresh the desktop file.
But after publishing this file to workspace(premium), it is taking around 20mins to complete each refresh.
All the connections are connected to Azure sql datases/ Azure Cosmos database and I'm using import query to load the data.
why is it taking such longer time? Is there any way to find which connection is blocking the refresh?
Regards,
Ananth
- GilbertQ
Super User
Hi there
When you say your connections are in Azure, which connections are you talking about?
And did you have to setup the Gateway in order to refresh the data?- v-anabatHi Gibert,
Thanks for the reply.
I mean that all my data is already present in Azure Sql db/ Azure cosmos database.
So, we don't need to setup gateway to connect to these connections.
Regards,
Ananth- GilbertQI would imagine it should be quick, unless the data is located in different regions?
