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
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..

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

    Hi Anonymous 

    If you want to expand a column 'Column1', you need to have this column in previous step's result. From your screenshot, the 'Converted to Table' step returns a blank table. It doesn't have Column1. And the 'GeneratedList' step also returns a blank result. Can you check above steps to see from which step the result starts to show blank? 

     

    And you say the report is refreshed correctly on another PC. What is the data source of this query? Is this PC able to connect to the same data source? Are you using the same crendentials to connect to the data source? 

     

    Regards,

    Jing