Expression.Error: Column ' ' of the table not found. Trying to refresh my query

Question

Trying to refresh the data from Source step, and I get this error. The column titles havent changed, but the error shows Warehouse Ti/Hi. Could this have something to do with the table from Access? I dont know, was hoping MS community could help me with this one. Thank you

Answer 1

Hi oktrey,

As per your description, please don’t worry we can work together to narrow down and resolve the situation.

The error message occurs when a column name changes or is removed altogether from the data source. In the background, Power Query is attempting to locate a specific column name that no longer exists.

The quickest solution is to go into the Power Query editor, locate the step that is causing the problem (most likely the "Changed Type" step), and remove the step completely.

In my example, I have loaded data from 3 columns and then deleted column 2. Now I had to remove all steps in Power Query which were related to this column so basically, I had to delete the text in red in screenshot below.

     

Per your error message , here are official article to fix this error, you may refer and check the outcomes: Dealing with errors in Power Query   

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 2

Thanks for your reply. I have tried to delete it from the Changed Type step. But I don't understand if there are two separate columns 'Warehouse Ti' and Warehouse Hi', yet in the error it is "Warehouse Ti/Hi". As far as I can tell, there isnt a column named this. They are two separate columns, and PQ should be able to locate them. Can you help me understand this issue better?

Answer 3

Hi oktrey,

Thanks for sharing updates with us and I really appreciate your effort and your precious time doing those tests. First, please accept my apologize you meet such an issue and I understand it effort on your daily work.

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation

You get error message because the power Query is unable to find a column heading , you may look your source data or some typo.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 4

Hi oktrey,

May I know have any updates regarding to this issue? Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad