Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Error refreshing dataflow

I'm getting the message below:

Error: Refreshing an entity exceeded the 2 hour refresh limit.

 

It's not clear what limit is being exceeded...is it the number of entities refreshed or the total amount of data?

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @pablop

 

Form the document, you can see: 

 

"Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premiumworkspaces. If you are encountering this limit, you can consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces."

 

In Power BI, dataflows behave the same behavior as Power BI datasets in terms of refresh settings. In your scenario, the error occurs due to the refresh exceed two hours limitation. You need to assign Premium capacity for the workspace which hosts the dataflow, or optimize the Power Query for entity to return less data. 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable

I met same error.

2 hours per entity, per dataflow, or sum of all dataflow refresh?

 

How to check exceed limit or not?

 

PerrigoNVanLent
Frequent Visitor

We are getting this error also...however, it shows up only 10 minutes after starting the refresh.