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)  ...
Need Help
Tutorial Requests
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.

menphis21's avatar
menphis21
Helper IV
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

      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 ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.

  • j_ocean's avatar
    j_ocean
    Helper V
    2 years ago

    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.