Forum Discussion

gingerbread's avatar
gingerbread
Frequent Visitor
4 years ago

Premium Capacity Utilization and Metrics - Dataset error - Unable to combine data

Hi all,

we are experiencing some issues with the data refreshing  of the Capacity Utilization and Metrics App from Microsoft. The refresh of the Dataset shows the following error: (See screenshot below)

The visuals of the report will not load

Could you please suggest what could be the issue or what should we do?

 

Thank you!

 

6 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support

    Hi, gingerbread 
    Are you using custom Premium Capacity Utilization and Metrics ?

    As mentioned in the error message, you need to check the level privacy settings of you datasource before publishing the report to service.

    Please refer to the solution in this similar thread.

    AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together 

     

    You can also consider solving this problem by moving the query to Data Flow and using Data Flow as a source in report.

    Power BI refresh error: Unable to combine data and workarounds 

     

    Best Regards,
    Community Support Team _ Eason

    • gingerbread's avatar
      gingerbread
      Frequent Visitor

      Hi v-easonf-msft , thank you for your feedback. We are using the standard app from microsoft. The account reading the data is a the Power BI Administrator user. We have no possabilities to see the power query or what exatly triggers this error. Is there a downloadlabe version of this report? 

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support

        Hi, gingerbread 

        No. There is no downloadlabe version of this report.

        If possible, please contact your Power BI Administrator to check the last time your Premium Capacity Metrics app refreshed. Refresh history may have more detailed error messages.

         

        Best Regards,
        Community Support Team _ Eason