Dynamic referencing error in power query

%3CLINGO-SUB%20id%3D%22lingo-sub-2255619%22%20slang%3D%22en-US%22%3EDynamic%20referencing%20error%20in%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2255619%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20dynamically%20reference%20a%20folder%20path%20so%20that%20the%20query%20is%20not%20broken%20if%20I%20send%20the%20file%20to%20someone%20else.%20I%20have%20the%20folder%20path%20saved%20in%20a%20table%20named%20FolderPath.%20I%20am%20using%20Folder.Files%20command%20to%20extract%20the%20files%20from%20the%20folder%20but%20once%20I%20hit%20the%20expand%20button%20on%20the%20content%20column%2C%20it%20says%20'we%20could%20not%20find%20an%20excel%20table%20named%20FolderPath.%20Not%20sure%20if%20it%20is%20a%20bug%20because%20it%20has%20worked%20for%20me%20in%20the%20past.%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2255619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2256062%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20referencing%20error%20in%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2256062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1017762%22%20target%3D%22_blank%22%3E%40Pratyush202%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20it%20looks%20like%20a%20bug.%20Can't%20find%20a%20workaround.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2257157%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20referencing%20error%20in%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwhere%20should%20I%20reach%20out%20for%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

I am trying to dynamically reference a folder path so that the query is not broken if I send the file to someone else. I have the folder path saved in a table named FolderPath. I am using Folder.Files command to extract the files from the folder but once I hit the expand button on the content column, it says 'we could not find an excel table named FolderPath. Not sure if it is a bug because it has worked for me in the past. What am I doing wrong?

 

Thanks

6 Replies

@Pratyush202 

Yes, it looks like a bug. Can't find a workaround.

@Sergei Baklan where should I reach out for help?

@Pratyush202 

I sent a frown from Help->Feedback, you may do the same. In addition you may open support ticket if you have such option.

Anyway, if some news I'll update here.

@Pratyush202 

For your information, I updated on

image.png

and here connector works correctly.

I am on office 365. Can I update to that version?

@Pratyush202 

That is insiders build. You may update if you have administrative right, that's free of charge. All instructions are here https://insider.office.com/, how to update depends on your subscription (consumer or enterprise).

 

At the same time, build I mentioned appeared about an hour ago. Perhaps other channels also will be updated soon, but I don't know.

 

If you decide to update on insiders build please not it could be with other bugs and, if you use some new functionality introduced in it, it could be incompatible in these parts with other people Excel apps.