Forum Discussion

Haydos89's avatar
Haydos89
Regular Visitor
2 years ago

Non-dashboard Resource Usage

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!

Administration
Administrative Reports
Administrator
report server administration

4 Replies

  • josef78's avatar
    josef78
    Memorable Member
    2 years ago

    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.

    • Haydos89's avatar
      Haydos89
      Regular Visitor
      2 years ago

      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.

    • Haydos89's avatar
      Haydos89
      Regular Visitor
      2 years ago

      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.

  • Haydos89's avatar
    Haydos89
    Regular Visitor
    2 years ago

    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?