recreate Usage Metrics report

[LDub]

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.

[LDub]

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.

[aduguid]

Can you share the DAX or M queries from Excel?