Forum Discussion

RadkaProefo's avatar
RadkaProefo
Regular Visitor
2 years ago

Dataflow is not refreshing

Hello fellows,

 

I have a big big problem with dataflow refresh. Tihs dataflow is connected to files in sharepoint (json, xlsx). I needed to make some changes, do I made a copy. Then I loaded a new column in one query and replaced one column in merge by this column. Everithing looks correct, dataflow saves. But it does not refreshes (connections are correct). It shows this mistake:

 

Error: Request ID: aa73004d-f5bf-6778-7765-c692ff61b117 Activity ID: c4cb787a-758e-4148-ba6a-fa734dc17081

 

Can anybody help me please?

 

Radka

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi RadkaProefo ,

     

    We can't check what the error is with the IDs etc you provided, are there other error messages?

     

    You can provide specific error messages via refresh history so that we can figure out the error. I have a related datafolw refresh troubleshooting article here that you can refer to.

    Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn

     

    If it does not help, please provide more details with the error.

     

    Best Regards,

    Yifan Wang

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

    • RadkaProefo's avatar
      RadkaProefo
      Regular Visitor

      Hello,

       

      that is the problem, there were no other error messages. When dataflow was open, all queries are loaded and all column profiles shows no errors (it is settled for all rows).

       

      Error message via refresh history is that one, I sent.

       

    • Element115's avatar
      Element115
      Memorable Member

      I got the exact same problem.  It's been like this for weeks now.  I tried everything, and even though the on-prem data loads into Power Query/DF Gen2, the automatic refresh that starts after you click publish ALWAYS FAILS!

       

      What's the solution?

      • RadkaProefo's avatar
        RadkaProefo
        Regular Visitor

        Hello,

         

        I still try to find a solution. I had a call with Power BI Microsoft support and they told me, that they cannot solve it, because it is a problem of Excel and I have to asi Excel Microsoft support.