cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Surm
Helper II
Helper II

Can Power Query detect the current report's path in report server?

Greetings!

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/*"

Is this doable?

 

1 REPLY 1
josef78
Super User
Super User

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.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.