Forum Discussion
Is it possible to access Azure Monitor for Storage Account UsedCapacity Metric from Power BI?
Hi GW999 ,
Unfortunately, there is currently no way to access Azure Metric data directly from Power BI. For the unsupported feature, you may submit an idea and vote for it: https://ideas.powerbi.com/ideas/.
This following article focuses on ways to feed data from Log Analytics into Microsoft Power BI to create more visually appealing reports and dashboards. Hope it helps you.
https://docs.microsoft.com/en-us/azure/azure-monitor/logs/log-powerbi
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many thanks for the reply Stephen. It's good to know that I am not missing a trick.
There is a KB from Microsoft (https://docs.microsoft.com/en-us/azure/azure-monitor/essentials/metrics-supported#microsoftclassicstoragestorageaccounts) that states that it is possible to export (route) Azure storage metrics data (specifically, UsedCapacity, which is what I need) to a Log Analytyics workspace. However, in reality when you try to configure this via the storage account's Diagnostics settings, the only metric available for selection is "Transactions". I have a support case open with Microsoft on that. They have confirmed the issue and are lookign at it for me, so fingers crossed we'll get this working. At that point I can use the KB that you linked.
Thanks again,
Garry
Hey GW999
Did you ever get any luck with this? We're trying to access the UsedCapacity metric from Log Analytics Workspace in order to write kusto queries for Azure Monitor capacity alerts.
Answers like this one: https://stackoverflow.com/a/76370753/361842 - show that others seem to have found a way to make this metric visible; but so far we've had no joy, and it sounds like you've been where we are.
Any help greatly appreciated - thank-you.
JB
