Azure cost analysis view for 12 months show with field name "Resource" after download to excel it display as "ResourceID"

Seng, Keangsim 1 Reputation point
2021-09-21T12:56:28.163+00:00

Dear SME,

I'm trying to view the view CostManagement with 12 months period and only built-in view I can choose, I want to have one mandatory field name "Resource" as it display in the Azure portal. The result after download to excel it display as "ResourceID" instead of "Resource".

The reason I want to see fieldname "Resource" in excel because of it short name and specific as per view in Azure portal, however the view in excel show as "ResourceID" which has long long naming.

Please advise how to customize or how to create own report with specific field name as per attachment "Azure cost analysis view for 12 months"

133838-azure-cost-analysis-view-for-12-months.png133839-costmanagement.png

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

1 answer

Sort by: Most helpful
  1. bharathn-msft 5,086 Reputation points Microsoft Employee
    2021-09-22T07:35:34.78+00:00

    <<Converting the information from comments here for broader community usage>>

    @Seng, Keangsim Welcome to Microsoft Q&A and thanks for your query.

    Regarding your specific query, currently only ResourceID or InstanceID are the attributes which get exported when you download the report or use the export option.

    Apologies that it is not meeting your requirement, I will check with our internal team once to understand if they have any roadmap item to enable resource attribute as well as part of download. If I hear any information on it, will get back to you.

    In parallel, would request you to have a look at the export option and since the data is stored in storage, you can write some customization to use the data in the storage container and create the table format you need.

    <<Update from our internal team - 9/24>>

    Currently there is no way to customize that in the portal, our recommendation would be to use the download option in cost analysis and customize the resource column using excel capabilities.

    Hope the above information helps. Let us know if you have any queries. Thank you

    0 comments No comments