Forum Discussion

LDub's avatar
LDub
Helper I
2 years ago

recreate Usage Metrics report

I would like to recreate the Usage Metrics report because I'm not able to download the .pbix. I don't have access to the Audit Log or API. So, I have the tables (Report Pages, Reprt Views, Users, etc) in Excel Pivot. Can anyone tell me what step to take next? I'm not familiar enough with the table fields to know which should go in rows vs columns in the pivot tables. All I want to do is recreate the report in Desktop so that I can then customize and add on to it.

Need Help

2 Replies

  • aduguid's avatar
    aduguid
    Memorable Member
    2 years ago

    Can you share the DAX or M queries from Excel?

  • LDub's avatar
    LDub
    Helper I
    2 years ago

    All I have in Excel is an empty pivot table. The data is in the PivotTable Fields pane with the tables you see in Service when editing the Usage Report.