Forum Discussion

RoskBI's avatar
RoskBI
Frequent Visitor
2 years ago

Azure Cost Management Connector & AWS Cost Management Connector

Hi there,

 

I am working with a multi-cloud org who is trying to view their Azure and AWS costs in Power Bi.

 

We have a working dashboard in Power BI using the Azure cost management connector https://learn.microsoft.com/en-us/power-query/connectors/azure-cost-management.

 

We have also setup an AWS integration https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/aws-integration-set-up-configure.

 

However, I cannot see the AWS costs which are visible in Azure Cost Management in Power BI desktop.

 

Can someone please confirm if this is possible? We are using the "usage details" report from Azure Cost Management Connector.

 

Thanks

Need Help
Tutorial Requests

2 Replies

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

    Hi, RoskBI 

     

    yes, it is possible. According to this MS  learn doc you  need a EA or MCA account for that. make sure you are using the correct account type and correct role to implement this setup. 

     

    Also make sure your data is not more than 1 milion, because data request more than 1 milion rows is not supported by PBI. 

     

    refer: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

     

    Also make sure you are using the right scope to view AWS data. available scopes are

     

     refer: Manage AWS costs and usage in Cost Management - Microsoft Cost Management | Microsoft Learn

     

    hope this will help.

    • RoskBI's avatar
      RoskBI
      Frequent Visitor
      2 years ago

      Hi thank you for your response and sorry for the delay.

       

      I appreciate your help. I understand we view AWS costs in Azure Cost Management (through the Azure Portal).

       

      However, we are trying to see AWS costs in Power Bi Desktop using the Azure Cost Management connector.

       

      Our logic was that we assumed because we can see our AWS costs in Azure, we should also be able to see these costs in Power Bi using the connector, however, we cannot seem to find them.

       

      Any further advice?

       

      Thanks,

      Matt