Can Power Query detect the current report's path in report server?
I have a Power BI report for "report usage" which queries pbirs report catalog. I would like this "report usage" report to discover (detect) its own path on power bi report server. Is this possible?
The goal is to copy this report to any folder on the power bi report server and the copy will automatically filter "report usage" data (coming from report catalog database) to display only reports that are in children folders.
For example, if I copy the "report usage" report to a folder "/division 1/branch 2", then this report should only display usage stats of the reports residing on "/division 1/branch 2/*"
I think not (this way). But if you planning copy report to each folder, I hope this report will be DirectQuery to DB, or Live Connected to SSAS (in my eviroment processing all pbi log in SSAS cube). And in this case you can use Paginated report (in Report Builder), where is easy detect and filter by report path.