Dataflow keeps failing refresh

[JWilczewski]

I have been trying to set up a dataflow and the table loads fine in the preview but it keeps failing in the refresh state.

This is the error I received: Error: Request ID: a464ff05-4f74-3723-1dbc-5d5a3a306fbd Activity ID: f0c80816-2831-4f7d-8518-94f28dd4a6ed

[v-linhuizh-msft]

Hi  @JWilczewski , 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution or mark the helpful replies, it will be helpful for other members of the community who have similar problems as yours to solve it faster . Thank you very much for your kind cooperation!

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[v-linhuizh-msft]

Thanks for the reply from GilbertQ and PDDP.

Hi @JWilczewski ,

You can think about things in terms of the following, including this scenario PPDDP mentioned.

Try to check the refresh failure history how a dataflow refresh operation performs, and review the Refresh History for the dataflow by navigating to Dataflow > Settings > Refresh History. 

The metrics for refreshing historical information can be viewed at this link:Understand and optimize dataflows refresh - Power BI | Microsoft Learn

Troubleshoot refresh scenarios - Power BI | Microsoft Learn.This link provides some ideas including checking  your gateway version. Update your gateway to the latest version, or a supported version to resolve this issue. 

Here are some videos that may be of help to you：

Best Power BI Dataflow Troubleshooting Tips - How To Fix Dataflow Issues (youtube.com)

What Happens When A Power BI DataFlow Refresh Fails? (youtube.com)

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[PDDP]

I have started to see this too.  I believe the issues I am running into result from using a Power BI Pro workspace with data flows that combine multiple sources tables (merges or appending tables).

[GilbertQ]

Hi @JWilczewski 

We would need more information to help you. Unfortunately, those ideas are of no value for us to help in troubleshoot.