Azure Resource Graph Explorer csv file download limitations

Question

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.

Answer 1

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 or upvote 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