Forum Discussion

menphis21's avatar
menphis21
Helper IV
2 years ago

Adding data to Usage Metrics Data report

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 

Need Help
Tutorial Requests

14 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      menphis21
      Helper IV
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.