Forum Discussion

kate_edwards's avatar
kate_edwards
Frequent Visitor
6 years ago

Refresh Queries

I am trying to refresh data and I have a Query built out for data that I am trying to import (Picture3). Whenever I refresh I get errors and it is because a new Query is showing up with steps that I have not built out (Picture 1). These errors are causing me to not be able to refresh the data and I do not know what I am doing to cause it.  These errors show up everytime I click refresh (Picture 2). 

 

Thanks!

 

Query steps that somehow appear when I refresh that has errorsAll the errors

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You can check that the data source is correct, usually if you are taking it from an excel file, you may have some fields with #NA(This is an error). You can verify in the same way, which rows or fields are generating the error, entering the generated table.

    • kate_edwards's avatar
      kate_edwards
      Frequent Visitor
      6 years ago

      It's adding steps (like adding an index and reording the columns) which I do not have in my own query. This has been happening on other data sets too, not just this one. 

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi kate_edwards ,

         

        What do you do for the other datasets? Are there the same steps as this one? For the current images shown, we don't understand clearly. Please show more details, like the error messages and the steps that you did.