Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dataflow keeps failing refresh

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

4 Replies

  • Hi Anonymous 

     

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

  • PDDP's avatar
    PDDP
    Advocate II

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply from GilbertQ and PDDP.


    Hi Anonymous ,

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  Anonymous , 

     

    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!