Hello @AJITH KUMAR RAI Thank you for posting your question on Microsoft Q&A platform. Happy to help!
I understand that you want to implement Cost Management report. I see that you mentioned you have Cost Management Reader permission on Azure subscription level. However, to view BillingProfileIdOrEnrollmentNumber you must be an Enterprise Administrator. The Enterprise Administrator (read only) role is supported.
Please refer to the "Prerequisites" section - https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/analyze-cost-data-azure-cost-management-power-bi-template-app#prerequisites
If you're an Azure enterprise administrator (EA admin), you can view enrollment details. Reference doc link - https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/direct-ea-administration#manage-your-enrollment
If you're an indirect EA, then your partner needs to grant you appropriate permissions to view EA account details. You can find the Billing Profile ID in the Azure portal by following these steps:
- Sign in to the Azure portal.
- In the left-hand menu, click on "Cost Management + Billing".
- In the "Cost Management + Billing" menu, click on "Billing profiles".
- Select the billing profile for which you want to find the ID.
- In the "Overview" tab, you will see the "Billing profile ID" listed under the "Properties" section.
Alternatively, you can use the REST API to programmatically get the Billing Profile ID. You can use the following API to get the list of billing profiles under a billing account.
GET https://management.azure.com/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/billingProfiles?api-version=2020-05-01
Replace {billingAccountId}
with the ID of your billing account. The API response will include a list of billing profiles and their IDs.
Hope this helps. Feel free to ping with question if need further assistance or you can also contact Azure billing and subscription management support by raising a support request to help you further in this matter.
Here is the link - https://docs.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request to create support case.
FYI: Azure Billing and Subscription Management support is included in the Basic Support Plan without any charge.
https://azure.microsoft.com/en-us/support/plans/
If the response helped, do "Accept Answer" and up-vote it