Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Cant See Query Errors In Power Query

I have a table that I load data into weekly, occasionally there are errors when I try to load, but when this occurs and I click "View Errors", the errors are not visible in Power Query.

 

I think this may be because I deleted the query group that displayed errors before.  If so, how do I re enable the errors to show in power query when they occur during data load?

 

 

Mark Janecek 

PTP Metrics Analyst

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Anonymous ,

     

    The error codes are regenerate at each "refresh" of the data so they should appear.

     

    One way to force it to appear just go to the query that has errors and make a small change (add a new step to your query) for example changing a name, renaming or making a sorting then when the model reuploads should return the error query,

     

    After checking the errors just delete the step you added.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I am going through a similar scenario, and repeated the above instructions. However, I am not seeing the error query return.

      • MFelix's avatar
        MFelix
        Super User
        3 years ago

        Hi Anonymous ,

         

        Is it not returning any errors anymore?