Forum Discussion
Solved
Power Query | Referencing | "We couldn't find an Excel table named 'TableName'
Hi Masters!
Can anyone please help me out of here? I also attached the file for simulation and reference.
Hi Ovette,
You shall add the function which picks up the content of each file, add what it returns as a column to your query and expand resulting table.
Please see attached.
Forgot to say, connector to the folder do the same automatically - attached
- Yes, I don't have trouble doing this via the connector but I was geared towards using a Parameter table(to be more dynamic)... where as a result gave me all this trouble.
