Reputation: 2922
Is there a way in a PowerBI Query to return the path of the workbook?
I am looking to create an environment variable that detects whether I am working on the file locally or if it has been deployed to the powerbi.com website.
Upvotes: 1
Views: 1300
Reputation: 2229
I'm not aware of a direct way to do this. You might try using the Folder source and see what the difference in result is when you run a refresh in the service (it could be disabled, btw) vs. when you run it on the desktop.
Could you also tell us why you'd like to know this? I'm sure there's a specific problem or scenario you're trying to solve for and maybe there's another way to solve it if not using the technique you're asking about in this question.
Upvotes: 0