Dataflow multiple refresh error

Hi Anonymous ,

According to your description, here is my suggestion.

There are two timeout thresholds for Power BI Pro dataflows:

1, two hours at the individual entity level

2, three hours at the entire dataflow level

Please check that if you have too large or too many tables.

And you can consider optimizing your dataflow queries, and consider using query folding on your source systems.

What’s more, you can consider upgrading to Premium Per User, which is not subject to three time-outs and offers increased performance due to many Power BI Premium Per User features.

Regarding the refresh failure, check whether the dataflow connected with SQL has a correct gateway connection which can be used normally.

If it still doesn’t work, try reconfiguring the scheduled refresh.

Please refer to the following documents.

Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ xiaosun

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