Usage Metrics - Dataset ID

[Radek_Lula]

Hi,

To collect the data of usage stats in automatic way for more than 30 days we want to collect this information in our database by first getting the data from PowerBI using API. But to achieve that we need datasetid of Usage Metrics Report.

For all our reports we see the dataset in the workspace and ID is within the URL. But we don't see dataset for usage metrics. 

How to easiest get this ID?

[Radek_Lula · Accepted solution]

I've got a solution using PowerShell if anyone interested

Loin to powerbi 

> login-PowerBI

To get workspaceIDs

> Get-PowerBIWorkspace | where name -like '*xyz*'

Then use this workspace id to get dataset id:

> Get-PowerBIDataset -workspaceid ID HERE | where-object {$_.name -eq "Usage Metrics Report"}