Forum Discussion
Azure services heath tracker - dashboard
Hello guys,
got interesting task recently and would like to consult it with you.
We have couple of applications running in and using various Azure Services (web apps, DBs etc). There is a first support line that handles all the error requests that are being called by users.
This support team would like to have a dashboard that will show status of each service per client/application.
I am wondering what is the best way to get those data to Power BI. I see below possiblities:
- use PowerShell and script some tasks that would populate Table Storage with data about each service, then connect to this service
- use Application Insights - but here we don't have all the informations about servies - like databases one
- Azure Stream Analytics - set up this service and connect to Power BI - isn't it more for IoT usage?
I would be really grateful for any advices or hints from your experience.
Thank you,
Rafał
2 Replies
- v-xicaiCommunity Support
Hi Anonymous ,
You can use Power BI Audit logs to audit actions done by users, like "View Report" and "View Dashboard". See more: https://docs.microsoft.com/en-us/power-bi/service-admin-auditing.
Or you can also use Usage metrics to discover how those dashboards and reports are being used throughout your organization, who's using them, and for what purpose. See more: https://docs.microsoft.com/en-us/power-bi/service-usage-metrics.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hey, thanks for the asnwer.
But I think you didn't get my point. I want to track Azure resources health, like key-vault, storages like cosmosDB and SQL DB, web apps, etc.
What I have discovered lately is Azure Monitor, you can import logs data to Power BI.
https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi
Do you think that would be a correct approach?
Rafal