Report Usage Metrics Dataset connect to AAS

[harakuruku]

Is there anyway to download/connect the Report Usage Metrics dataset to AAS? Or to any data warehouse? Thank you!

[GilbertQ]

Hi there.

you should be able to view the Usage Metrics on the reports in terms of who used and viewed the reports.

If you are looking for any other metrics you would need to get that from AAS

[harakuruku]

Thanks!

But what I really need is to copy the dataset of the Usage Metrics so I can manipulate it's data or created calculated columns.

[v-piga-msft · Accepted solution]

Hi @harakuruku,

We could make a copy of Report Usage Metrics in Power BI Service, then connect to Power BI Service in Power BI Desktop and select Dashboard Usage Metrics Model or Report Usage Metrics Model you have created, then you could get the dataset of the Report Usage Metrics.

Best Regards,

Cherry

[DanP]

Did this work for you? I made a copy of the report but cannot connect to it's dataset. I am able to connect to any other dataset I have created but the usage metrics seem different.

Get the following message:

An error occurred while loading the model for the item or data source 'OpenConnectionError'. Verify that the connection information is correct and that you have permissions to access the data source.

I have given myself read/reshare privileges on this dataset.