Datalake refresh timing out or taking longer than in Desktop

[username2345]

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.

[Anonymous]

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) 

• 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.

[lbendlin]

If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/