How to export 5000+ line items in Azure?

anil kumar 1,646 Reputation points
2023-07-18T15:06:58.8333333+00:00

Hello there,

Greetings of the day!

We have few thousands Azure resources created for a customer - When we try to export info about those resources, there is a limit of 5000 records export. I find this limitation weird, how do we export 30K+ line items in one shot?

Applicate your Response. Thank you!

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,998 questions
{count} vote

2 answers

Sort by: Most helpful
  1. SadiqhAhmed-MSFT 48,351 Reputation points Microsoft Employee
    2023-07-21T14:44:33.7233333+00:00

    Hello @anil kumar Thank you for sharing the below screenshot.

    User's image

    I think the UX is relying on Query API to download the data being used to render the visual.  

    What dataset are you trying to download? 

    If you want raw usage dataset, then Cost Management Exports is the right option: Tutorial - Create and manage exported data from Cost Management - Microsoft Cost Management | Microsoft Learn

    **
    Update:

    We currently support 50k in ARG explorer, so the workaround right now is to click "Open query" on the relevant page (screenshot just uses All Resources) and use the export experience "Download formatted results as CSV" on ARG Explorer. I've attached screenshots below of this flow:

     User's image

     

    We're in the process of updating the logic in Browse (the experience in the first screenshot) to also support 50k in exports.


    If the response helped, do "Accept Answer" and up-vote it

    1 person found this answer helpful.
    0 comments No comments

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.