Forum Discussion

menphis21's avatar
menphis21
Icon for Helper IV rankHelper 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 ,

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
Icon for Helper IV rankHelper 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.

    • menphis21's avatar
      menphis21
      Icon for Helper IV rankHelper IV
      2 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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.