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

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

    • 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.