Forum Discussion
Power Query | Referencing | "We couldn't find an Excel table named 'TableName'
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.
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.
Thank you for the idea, I was able to create that function and I am rolling now...
Big THANKS!!!
Can you can you explain what you did in detail for me please? Im a bit of a beginner. I’m having the same error that you did in your first post. I’m wanting a dynamic query folder path. When I click on double expand arrows I get the cannot find table name table2 error.
Im using power query (should have same solution as power bi though).
GohLazar Yes, this is much easier than the route I took before.
