Forum Discussion

CheikhnaML's avatar
CheikhnaML
Frequent Visitor
5 years ago
Solved

Using drill down to make a dynamic path

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 ...
Need Help
  • CheikhnaML's avatar
    CheikhnaML
    4 years ago

    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

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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's avatar
    CheikhnaML
    Frequent Visitor
    4 years ago

    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