Forum Discussion
Solved
Usage Metrics - Dataset ID
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 ...
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"}