Column1 not found

[Anonymous]

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 fine. I've double checked the query and all seems finez. Can anyone help?

I've cleared the cache and cleared permssions with no luck.

Thanks in advance.

[amitchandak]

@Anonymous , do you have any column1 in query, which is missing now. 

Or a Step where this has been deleted and used in a later step?

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

[Anonymous]

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

 

[v-jingzhang]

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]

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]

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