cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Radek_Lula
New Member

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 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?

1 ACCEPTED SOLUTION
Radek_Lula
New Member

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"}

View solution in original post

1 REPLY 1
Radek_Lula
New Member

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"}

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors