Azure Resource Graph Explorer csv file download limitations

LaBombard, Lory 41 Reputation points
2022-07-18T16:42:19.06+00:00

When I try to download Resource Graph Explorer query results to a .csv file that contain over 300,000 results, I receive a message that says " the result has too many data points to download. Continue to download the first 55000 results if you don't mind waiting, or download the first 5000 results right away. "

Is there a way to download all of the results and/or to automate them to be exported? We need to have reoccurring queries extracted on a weekly basis for reporting requirements. Thank you!

Also, I couldn't find a relevant tag to select for this so that it will save.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,667 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,700 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Kamlesh Kumar 3,861 Reputation points
    2022-07-20T13:44:10.907+00:00

    Hi @LaBombard, Lory ,

    Welcome to Microsoft Q&A Platform. Thank you for the question.

    I would suggest in this case explore the Rest API which might be helpful for your. I am sharing some Microsoft document link for the reference,

    https://learn.microsoft.com/en-us/azure/governance/resource-graph/first-query-rest-api
    https://learn.microsoft.com/en-us/rest/api/azureresourcegraph/resourcegraph(2021-03-01)/resources/resources?tabs=HTTP#examples
    https://learn.microsoft.com/en-us/azure/governance/resource-graph/concepts/explore-resources

    Regards,
    Kamlesh Kumar

    Please don't forget to click on 205836-130616-image.png or upvote 205759-130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How

    Want a reminder to come back and check responses? Here is how to subscribe to a Notification

    If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators