Adding data to Usage Metrics Data report

[menphis21]

Hi,

I want to add a table from SQL to the Usage Metrics Report ?
how can i do ?
I saved as the app to try to modify but cannot add data, cannot change the connection type ( Or dont know how)

Thank you 

[Anonymous]

Hi @menphis21 ,

To dig into the report data, or to build your own reports against the underlying dataset, you have several options:

• Make a copy of the report in the Power BI service. Use Save a copy to create a separate instance of the usage metrics report, which you can customize to meet your specific needs.
• Connect to the dataset with a new report. For every workspace, the dataset has the name "Usage Metrics Report," as explained earlier in the section Usage metrics report dataset. You can use Power BI Desktop to build custom usage metrics reports based on the underlying dataset.
• Use Analyze in Excel. You can also analyze the Power BI usage data in PivotTables, charts, and slicer features in Microsoft Excel. Read more about the Analyze in Excel feature.

For more details, you can read related document: Monitor usage metrics in workspaces (preview) - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[menphis21]

Hi @Anonymous ,

Thank you.

for the first two options, when you are connecting to the dataset of Usage Metric report, you cannot add any table on the dataset and thats why i need.

Also when you saved as copy, you cannot add anything its blocked.

About using Analyse in Excel, its manually, so i will need to redo the work the next month.

Am i missing something ?

[Anonymous]

Hi @menphis21 ,

You could connect to Usage Metrics dataset in Power BI Desktop with Direct Query connection type, for this connection type you colud get data from other data source, then you could create your report with data.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[menphis21]

@Anonymous  Can you explain me please how can i do it ? Its a power bi dataset right ?
Where should i change the connection type ? i have no options like that

[j_ocean]

Go to Model Tab, properties, advanced, Storage Mode, Direct Query.

If that doesn't work try making a calculated table. Any old table will do. Hopefully it'll give it the kick to pop up the dialog box to set up a composite model.

Be warned that such a pbix won't update in Service, microsoft made the usage metrics some special little flower that's specifically exempt from being able to be refreshed in service.

[Anonymous]

Hi @menphis21 ,

Usage Metrics dataset is a Power BI Dataset, when you connect to PBI Dataset in Power BI Desktop, the default connection type is Live Connection, but when you connect to other data source after had connected to Usage Metrics dataset, the storage mode will change to Mixed.

So you could create a Mixed storage mode to create your report.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[menphis21]

HI @Anonymous ,

Thank you. But thats my problem, i cannot connect to other data source because i am already connected to Usage Metrics dataset. (screenshot below)
I am missing something ?

[aj1973]

Hi @menphis21 

You need to do this connection differently.

Start by connecting to your SQL Tables in Import Mode then Get Data to connect to AAS in order to get the Dataset from the service.

[Anonymous]

Hi @menphis21 ,

What is your version of Power BI Desktop?

It works well in my environment.

If your version are too older, you need do some configuration in options in Power BI Desktop.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[menphis21]

@Anonymous  Version: 2.122.1066.0 64-bit (october 2023)
I aslo activate all the features wihtout success

[Anonymous]

Hi @menphis21 ,

Please confirm your administrator has enable this options in Power BI Admin Portal:

For more details, you can read related document: Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[menphis21]

@Anonymous Hi,

I am still trying to find a solution 
@ibarrau @lbendlin @GilbertQ @aj1973 @pmreis @Brunner_BI @arvindsingh802 

[aj1973]

Hi @menphis21 

You need to use Power BI Rest APIs to export metrics report to a local machine then use Power BI to connect to these exported files and to the table from SQL. Build your report

[menphis21]

@ibarrau @lbendlin @GilbertQ @aj1973 @pmreis @Brunner_BI @arvindsingh802