- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Datalake refresh timing out or taking longer than in Desktop
Hi,
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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)
- try to use dynamic 365 query function in Power Query to filter the dataset
- you can increase the timeout limit for the query
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-06-2024 08:18 AM | |||
05-06-2021 02:09 AM | |||
09-28-2024 10:11 AM | |||
12-16-2024 02:01 AM | |||
09-23-2024 09:41 AM |