Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Datalake refresh timing out or taking longer than in Desktop



I am currently refreshing a pbix file which is about 13mb and returns a dataset that is about 1 million rows that reads json files stored in azure data lake gen 2. 


When I refresh the report in power bi desktop, it works and refreshes in about 30 mins or less (16gb ram computer) but in service it has been taking longer (between 1 hr and 2hrs ) and no it has been completely timing out with the below;


Last refresh failed: Tue May 10 2022 13:39:41 GMT+0100 (British Summer Time)
The refresh operation failed because it took too long to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets.


There's no way I can make the dataset smaller and confused as to why the refresh is now taking so so long to refresh.


I do have plans to move this all into azure sql but I don't have the skills for that just yet so if anyone can help with understanding the behaviour.


Community Support
Community Support

Hi @username2345 ,

It appears to be a timeout issue. Have you tried using incremental refreshing to solve this and refresh per day instead of the entire dataset? Can you try to download the schedule refersh failed pbix file , open and refresh it on the Power BI Desktop ?


Why refresh time longer on Power BI Service?

The queries being sent in your report are dispatched by azure service bus. Azure service bus all operate others queries so part of queries will be hang up until azure service bus open the permission for them. For more details, please refer to documentation here:

What is Azure Service Bus? 


I have also found a similar post, please refer to it to see if it helps you.

Dataset refresh takes too long error (PowerBI online) 

If it doesnot help, please provide more details.


Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Super User
Super User

If you have a Pro license you can consider raising a Pro ticket at

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors