Using drill down to make a dynamic path

[CheikhnaML]

Hi everybody and thank you for all the support you provide. 

I am not very advanced in using power bi destktop and the query editor. 

Here is my issue : 

I have some data that comes from a txt file called data. 

I uploaded this data in my power bi query editor. 

Then I want the upload to be dynamic, so I created an excel file called "masterfile" that has a named range called "fileName". 

Then I uploaded this named range into my query editor and used "drill down" to have the value and I called in "FileName"

I replaced the static path inside my M formula with "FileName" that I just created, whose value is the same than the static value. 

But it does not work. Here is the error message that I get

I attached both files for better understanding. 

Thank you in advance. 

[CheikhnaML]

@mahoneypat have you had the time to look up my previous comment ? Thank you for your help

[mahoneypat]

Your syntax looks correct.  Make sure the output of your FileName query looks like this in the query editor (no double quotes around it).

Pat

[CheikhnaML · Accepted solution]

@mahoneypat Thanks for your answer. 

It had already removed the double quotes but it didn't work. 

I eventually found the solution : maybe it might help someone in the future : 

To resolve this error, change the privacy settings in the query editor by going to File/Query and options / Query options / Current file / Privacy / Select "ignore the privacy levels and potentially improve perofomance". 

Best regards

[Anonymous]

Thanks for sharing!

[mahoneypat]

In your second picture, it looks like your FilePath text is actually being used as the column header (not the first row).  You need to change that query so that the you see text instead of the empty list you are seeing.

Pat

[CheikhnaML]

Thanks for the reply. 

I did that and now I have this in my filename : 

But is still doesn't work, as when I replace the static filepath in my formula by "FilePath", this is the error message that I get : 

Thanks in advance for your help