Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Column1 not found

Getting the dreaded column1 not found error when refreshing a dataset which has previously work fine for several months, a colleague is able to refresh the data using the same report on his desktop f...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    Yes, query includes colum1. Do I need to change this?

     

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Hi Anonymous 

      This error usually occurs when a step cannot find a column by name it refers to. Can you click its previous step to check the names of columns. Is there any uppercase/lowercase difference or space in original column name? In Power Query Editor, column names are case sensitive. Find the last step which doesn't have an error and start to check its following steps one by one to correct the errors.

       

      Regards,
      Community Support Team _ Jing
      If this post helps, please Accept it as solution to help other members find it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks for your reply, the previous steps is converted to table, its obviously looking for column1 which is not there. How to I get the table to convert correctly as it should show a column1?

         

        Is frustrating as when the report is refrshed on another PC it works correctly, feels likes its a corrupted cache but I could be wrong as new to Power BI.

         

         

        step before convert to table..