The current Usage Details (Usage and purchase) csv file is too large to bring into Excel. Is there a way to just filter for Charge Type of "Purchase" with all the same fields as contained in the Usage and Purchase csv file? Our daily Azure import does not include the Purchases and now that our company is using more Reservations, we need to have a process to bring in this data.
Thank you,
Dawn M Kassube
QBE Insurance
@51621659 Thank you for reaching out to us with your concern. Happy to assist!
I see that you have a requirement to export "Purchase" Charge Type with the same fields as contained in the Usage and Purchase csv".
Have you looked at https://docs.microsoft.com/azure/cost-management-billing/costs/tutorial-export-acm-data? Data exports from Cost Management export the same info as Usage and Charges and usage details. You can set a date range. And, you can use file partitioning to create separate chunks for very large files.
If the response helped, do "Accept Answer" and up-vote it
6 people are following this question.
