Column1 not found

Question

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 · Answer

Anonymous , do you have any column1 in query, which is missing now.&nbsp;
Or a Step where this has been deleted and used in a later step?
&nbsp;
debug issue https://www.youtube.com/watch?v=OE6DPmKqN7s

anonymous · Answer

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

v-jingzhang · Answer

Hi&nbsp;Anonymous&nbsp;
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?&nbsp;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.
&nbsp;
Regards, Community Support Team _ JingIf this post helps, please Accept it as solution to help other members find it.

anonymous · Answer

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?&nbsp;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.&nbsp;&nbsp;step before convert to table..

v-jingzhang · Answer

Hi&nbsp;Anonymous&nbsp;
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?&nbsp;
&nbsp;
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?&nbsp;
&nbsp;
Regards,
Jing

Forum Discussion

Column1 not found

5 Replies

Related content

"The column 'Column1' of the table wasn't found."

Expression.Error: The column 'Column1' of the table wasn't found.

DataSource not found

Transform Column1 to ColumnHeaders

Gen2 Dataflow Refresh Failure - Staging Lakehouse Not Found