Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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"}
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"}