SOLVED

Power Query | Referencing | "We couldn't find an Excel table named 'TableName'

Copper Contributor

Hi Masters!

 

Can anyone please help me out of here? I also attached the file for simulation and reference.


PQ_CouldntFindTable_032118.PNG

8 Replies
best response confirmed by Ovette Abejuela (Copper Contributor)
Solution

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.

image.png

Please see attached.

Forgot to say, connector to the folder do the same automatically - attached

Sir,

Excited but how did you do this I think you attached the same file.
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.

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). 

 

 

 

 

 

@Ovette Abejuela 

@GohLazar Yes, this is much easier than the route I took before.

1 best response

Accepted Solutions
best response confirmed by Ovette Abejuela (Copper Contributor)
Solution

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.

image.png

Please see attached.

View solution in original post