October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Is there a way to import certain columns from Azure Cost Management or does it have to be the full table? Our dataset is prohibitively large.
Solved! Go to Solution.
Hi @RShackelford ,
Azure Cost Management's export feature itself does not support exporting just one column; it can only export the entire table. I also checked the REST API related to Azure Cost Management and it seems that the interface related to exporting only a column does not exist.
If you are loading too slowly due to the sheer volume of data in the entire table, I would suggest that you try the partitioned export for large datasets mentioned in that document, which may perhaps optimize your performance in this regard.
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-export-acm-data?tabs=...
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-improved-exports
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RShackelford ,
Azure Cost Management's export feature itself does not support exporting just one column; it can only export the entire table. I also checked the REST API related to Azure Cost Management and it seems that the interface related to exporting only a column does not exist.
If you are loading too slowly due to the sheer volume of data in the entire table, I would suggest that you try the partitioned export for large datasets mentioned in that document, which may perhaps optimize your performance in this regard.
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-export-acm-data?tabs=...
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-improved-exports
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.