Forum Discussion

jeffmasse's avatar
jeffmasse
Frequent Visitor
7 years ago

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's avatar
v-anabat
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

even 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's avatar
v-anabat
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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