Hi everyone,
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.
JG
Hi Jose,
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.
Check out my Power Query course where I cover more quirks like this, plus techniques for automating boring tasks.
Mynda
Thank you, that was helpful!
Jose
