Forum Discussion

bhatsuchi's avatar
bhatsuchi
Frequent Visitor
8 years ago

Using the Usage Metrics dataset with other datasets

Hi,

 

I am trying to use the Usage metrics dataset of one of my dashboards and create another report with additional datasets from SQL server tables. However, I am unable to get data from any other source in the same report that has the Usage metrics dataset.. Get data is disabled in the report that uses the usage metrics dataset. Is there a workaround to do this?

 

Thanks,

 

Suchitra

Need Help

6 Replies

  • bhatsuchi's avatar
    bhatsuchi
    Frequent Visitor
    8 years ago

    Hi,

     

    I am trying to use the Usage metrics dataset of one of my dashboards and create another report with additional datasets from SQL server tables. However, I am unable to get data from any other source in the same report that has the Usage metrics dataset.. Get data is disabled in the report that uses the usage metrics dataset. Is there a workaround to do this?

     

    Thanks,

     

    Suchitra

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      8 years ago

      Hi bhatsuchi,

       

      Connecting to a dataset in power bi service, this is a kind of live connection, so modeling is disabled, similar to the behavior when connecting to SQL Server Analysis Services. So it is not possible to meet your requirement. For more details, please check the online document.

       

      Regards,

      Frank

      • bhatsuchi's avatar
        bhatsuchi
        Frequent Visitor
        8 years ago

        Thanks for your response, Frank. Do you think there is any other way that I could achieve this? My specific requirement is to map the users from the usage metrics report to their roles in the organisation, and the roles is in another database table to which I need to join on the alias(which I can get from the usage metrics report).

        Thanka again!