topic Re: Non-dashboard Resource Usage in Report Server

Non-dashboard Resource Usage

Haydos89 — Sun, 11 Feb 2024 23:11:32 GMT

Context

Our administrator has created a dashboard that shows a count of how many times users have viewed Power BI dashboards in the last 60 days. The dashboard can be filtered by folder path, and includes additional information like "Latest TimeStart". It is very useful!

Problem

Only Power BI dashboards are in-scope to be counted. It does not count non-dashboard resources (such as Excel workbooks and Word files) that are also saved on the Report Server.

Question

Can a dashboard be created that identifies how often non-dashboard resources are viewed/downloaded from the Report Server?

Thanks in advance!

Re: Non-dashboard Resource Usage

josef78 — Mon, 12 Feb 2024 09:01:40 GMT

I suppose, this report is based on ExecutionLog3 view, there is detailed log about both, paginated reports and PBI reports (dashboards), for interactive view, or background refresheses or schedules.

But Excel od Word, is minimum loged, becasuse in fact, Excel and Word is not rendered on Power BI Reports server, but thru iframe on another Office Web Apps server. But maybe minimum, try look on ReportActions like GetExcelWorkbookInfo or RenderExcelWorkbook.

Re: Non-dashboard Resource Usage

Haydos89 — Mon, 12 Feb 2024 23:40:43 GMT

Thanks for your suggestion josef78! I'll raise this with our System Administrator and see if ReportActions can support our requirements. If it does, I'll accept this as the Solution.

Re: Non-dashboard Resource Usage

Haydos89 — Wed, 28 Feb 2024 01:51:15 GMT

I've just recieved feedback from the System Administrator team that the Report Action column does not capture actions for non-PBI documents such as ".xlsx" or ".docx". It only captures actions "Render" and "Unknown".

Thanks again for the suggestion josef78, but it looks like we are going back to the drawing board.

Re: Non-dashboard Resource Usage

Haydos89 — Wed, 28 Feb 2024 01:59:16 GMT

Is there a way to report when users "Download" a report, so that we can capture when users are interacting with "DOCX" or "XLSX" files?