Forum Discussion

MRosk15's avatar
MRosk15
New Member
2 years ago

AWS Costs via Azure Cost Management Connector into Power Bi

Hi there,

 

I am looking for support to visualise AWS Costs in Power Bi by leveraging the Azure Cost Management Connector.

 

We have an existing Power Bi Dashboard leveraging the Azure cost management connector https://learn.microsoft.com/en-us/power-query/connectors/azure-cost-management.

 

The organisation has setup an AWS integration to Azure Cost Management https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/aws-integration-set-up-configu...

 

However, the AWS costs which are visible in Azure Cost Management ARE NOT showing up in Power BI desktop.

 

Is this a limitation? or is there an additional configuration that's required for this functionality? 

 

 

Need Help

1 Reply

  • mohit_sakhare's avatar
    mohit_sakhare
    Icon for Resolver II rankResolver II
    8 months ago

    Hi,

    This is a known limitation of the Azure Cost Management Power BI connector.

    Even though AWS costs can be imported and viewed inside the Azure Cost Management portal, the Power BI Azure Cost Management connector only supports native Azure billing scopes (subscriptions, resource groups, billing accounts, management groups). It does not expose the AWS–Azure integrated cost data through the connector’s API endpoint.

    In other words:

    • Azure Portal → Cost Management shows AWS costs

    • Azure Cost Management API → Power BI connector returns Azure-only data

    This is not a configuration issue — it’s a product gap.

    Why this happens

    The AWS integration stores data in Azure Cost Management as a linked billing dataset, but it is not published through the Cost Management Query API that Power BI uses. The connector simply can’t see it.

    Microsoft documents the AWS integration mainly for:

    • Portal reporting

    • Exports

    • Cost analysis UI

    Not for Power BI API consumption.

    What are your options?

    Option 1 — Use Cost Management Exports (recommended)

    In Azure Cost Management:

    • Configure Exports to export the combined Azure + AWS cost data to:

      • Azure Storage

      • Azure Data Lake

    Then in Power BI:

    • Use ADLS Gen2 / Blob Storage connector

    • Read the exported CSV/Parquet files

    • Build your AWS + Azure reporting from there

    This is Microsoft’s supported enterprise pattern.

    Option 2 — Pull AWS costs directly from AWS

    Use:

    • AWS Cost and Usage Report (CUR) to S3

    • Or AWS Cost Explorer API

    Then load that into:

    • Azure Data Lake / Fabric

    • Or directly into Power BI

    This gives more control and better granularity than Azure’s AWS integration.

    Bottom line

    There is no way today to see AWS costs via the Azure Cost Management Power BI connector.
    If you need AWS + Azure cost reporting in Power BI, you must use Exports or AWS-native data sources.

    This is a platform limitation, not a misconfiguration.