May 8, 2022
I am very new to Power Query and coming across an error that I'm sure has to be an easy fix.
I have two files in a folder located on a shared drive.
I connected to a folder that currently has two files. The files are structured exactly the same way. Each file has a table and same exact columns. When I connected, I clicked on Combine & Transform Data.
I made all my transformations on the Transform Sample File, I created connection only and added to data model and then came across this error.
What step am I forgetting?
Any assistance would be greatly appreciated.
July 16, 2010
Welcome to our forum!
This error is caused by a name being referred to in your query for specific table or column names that are no longer present in your source data. e.g. when you originally built the query a table might have been named TableA, but now it's named TableB and therefore the query can't find TableA. Of course it could also be renamed columns.