jpreciado's avatar
jpreciado
Regular Visitor
5 years ago
Status:
New

Dataflow cannot be refreshed or edited

A dataflow that has been working for 8 months started failing this morning.  We can not refresh or edit the dataflow which is preventing us from examining and correcting the problem.  We've tried to access it on different browsers, machines, and as different users.  Is this a transient issue or is there an action that needs to be taken to fix it?

 

 

9 Comments

  • jpreciado's avatar
    jpreciado
    Regular Visitor

    I tried clearing cache and we tried editing the dataflow on different computers.  We get the same erorr when we click "Edit Entities" on the Dataflow

     

     

  • fkrijgs's avatar
    fkrijgs
    Regular Visitor

    Hi,

     

    jpreciado I have the same problem since last week. I can't refresh or change anything.

     

     

    v-chuncz-msft 

    I have copied the Mashup-text into word and then I added each query one by one to a new dataflow. Apparently there was suddenly an error in one query even though it has been running for several months without any problems.

     

    It apparently had to do with the following line in the query:

     

    NL: #"Geëxtraheerde datum" = Table.TransformColumns(#"Namen van kolommen gewijzigd", {}),

    EN: #Extracted date" = Table.TransformColumns(#"Changed column names", {}),

     

    When I remove this line, my new dataflow does work.

     

  • wintergolem's avatar
    wintergolem
    Frequent Visitor

    I'm having the same issue. Looks like power query is breaking anytime it's launched and the mashup text holds corrupted queries from everytime that user tried to edit a query. I switched browsers but the mashup text is still a massive list of query on top of query. I don't have the orginal queries so I'm stuck in limbo. I might be able to rebuild them and upload them, but if they break again I'm stuck in the same spot!