Billing and Costing Data in Azure to Power BI

Kaki Sai Sudharshan (iCORE-CIS) 41 Reputation points
2022-10-04T12:46:59.607+00:00

Hi All,

I am trying to get the billing and costing data from azure to Power BI. I am aware of one process that is using Azure Cost Management Connector in Power BI.
Now, i want to get the data using APIs and i came to know of this link (https://learn.microsoft.com/en-us/rest/api/billing/enterprise/billing-enterprise-api-usage-detail#usage-details-field-definitions) where we are having some APIs.
As i checked from this link (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management) there it is mentioned like "The Azure Cost Management connector doesn’t support pay-as-you-go Microsoft Customer Agreements or indirect Microsoft Customer Agreements." Is this applicable to EA aswell and will i get the PayG, RI data for the EA model.
Also please let me know, if i can get the data of Costing and Billing without the Enrollment Number and some other details (like directly with the help of Subscription ID and all). Even PowerShell is also fine.
Please let me know any of the methods, if i can get the data.

Thanks

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,104 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. dkrishnaveni-MSFT 1,946 Reputation points Microsoft Employee
    2022-10-04T17:40:54.767+00:00

    Hello Kakisaisudharshani,

    Currently Azure cost management connector in power BI only supported for direct MCA customers and Enterprise Agreement customers. It is not yet supported for Pay-as-you-go or indirect MCA customer.

    When it comes to enterprise agreement customer type enrollment number is mandatory and added as billingaccountsId and billingprofileId in scope identifier step as shown below.

    /providers/Microsoft.Billing/billingAccounts/{billingAccountId}/billingProfiles/{billingProfileId}

    Plesae note user will be prompted to login, where user must login using their EA admin credentials. RI data will be available using this feature. Please find the below document for available data through this connector.

    Reference document section: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management#data-available-through-the-connector

    Regards,
    Divya.