Forum Discussion
Using drill down to make a dynamic path
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 have you had the time to look up my previous comment ? Thank you for your help
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
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
Thanks for sharing!