SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-174133%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174133%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20the%20idea%2C%20I%20was%20able%20to%20create%20that%20function%20and%20I%20am%20rolling%20now...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBig%20THANKS!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174117%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174117%22%20slang%3D%22en-US%22%3EYes%2C%20I%20don't%20have%20trouble%20doing%20this%20via%20the%20connector%20but%20I%20was%20geared%20towards%20using%20a%20Parameter%20table(to%20be%20more%20dynamic)...%20where%20as%20a%20result%20gave%20me%20all%20this%20trouble.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174114%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174114%22%20slang%3D%22en-US%22%3ESir%2C%3CBR%20%2F%3E%3CBR%20%2F%3EExcited%20but%20how%20did%20you%20do%20this%20I%20think%20you%20attached%20the%20same%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174095%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174095%22%20slang%3D%22en-US%22%3E%3CP%3EForgot%20to%20say%2C%20connector%20to%20the%20folder%20do%20the%20same%20automatically%20-%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174093%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174093%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ovette%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20shall%20add%20the%20function%20which%20picks%20up%20the%20content%20of%20each%20file%2C%20add%20what%20it%20returns%20as%20a%20column%20to%20your%20query%20and%20expand%20resulting%20table.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20421px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F30687i76FB70D91B90BF67%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20see%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174068%22%20slang%3D%22en-US%22%3EPower%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174068%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Masters!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20anyone%20please%20help%20me%20out%20of%20here%3F%20I%20also%20attached%20the%20file%20for%20simulation%20and%20reference.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20789px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F30680iC8BEEA481B8AF675%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PQ_CouldntFindTable_032118.PNG%22%20title%3D%22PQ_CouldntFindTable_032118.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-174068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894571%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20%7C%20Referencing%20%7C%20%22We%20couldn't%20find%20an%20Excel%20table%20named%20'TableName'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894571%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20can%20you%20explain%20what%20you%20did%20in%20detail%20for%20me%20please%3F%20%26nbsp%3BIm%20a%20bit%20of%20a%20beginner.%20I%E2%80%99m%20having%20the%20same%20error%20that%20you%20did%20in%20your%20first%20post.%20I%E2%80%99m%20wanting%20a%20dynamic%20query%20folder%20path.%20%26nbsp%3BWhen%20I%20click%20on%20double%20expand%20arrows%20I%20get%20the%20cannot%20find%20table%20name%20table2%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20using%20power%20query%20(should%20have%20same%20solution%20as%20power%20bi%20though).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F90098%22%20target%3D%22_blank%22%3E%40Ovette%20Abejuela%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ovette Abejuela
Occasional Contributor

Hi Masters!

 

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


PQ_CouldntFindTable_032118.PNG

6 Replies
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.
Highlighted
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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies