Kevin Hammond on 12 Feb 2015 11:40:24
Make it possible to connect directly to Azure billing data and generate reports and dashboards that a customer can use for charge back, understand consumption, predict usage growth, etc.
- Comments (5)
RE: Azure Billing Data
You can do this now. This fellow built an excel model: http://www.edmondek.com/Azure-Usage-Analytics-Report-Feb-2017-Update/
You can import the data model and query into Power BI. You can use it directly or simplify it. He created a separate date table to allow reporting by month, but you don't need that in Power BI if you use the automatic date binning feature
RE: Azure Billing Data
Is this being developed for customers who are not EA customers?
RE: Azure Billing Data
The Azure Enterprise content pack is a step forward but only works via the web version of Power BI, the desktop version is still more feature rich, I think it would be good to allow the desktop version to connect to the billing API.
RE: Azure Billing Data
There is a Azure Enterprise content pack published last week.
RE: Azure Billing Data
This would be really helpful. I use Readify Lab's experiment to accomplish this today for my enterprise agreement reporting: https://azureea.labs.readify.net/