Azure monitor SQL db monitoring

Grafana Azure Monitor
1

Using docker grafana 8.4.1 and I want to see SQL DB metrics from azure in grafana.
In azure I have created LogAnalytics workspace on top of that I have added Azure Sql Analytics (preview), connected all databases to it, added service principals where necessary, and in azure I see the database metrics as I am supposed to.
Now in grafana, I have connected Azure Monitor datasource and imported its dashboards.
For example Azure Resource Overview works like a charm and Azure Storage Insights one aswell, indicating the connection to Azure works.
What doesn’t work is Azure Sql Database dashboard.

2022-04-08 10_18_07-Azure SQL Database - Grafana
2022-04-08 10_18_07-Azure SQL Database - Grafana574×796 69.9 KB

2022-04-08 10_19_53-Azure SQL Database - Grafana
2022-04-08 10_19_53-Azure SQL Database - Grafana1647×516 28.6 KB

PS: I have followed MS documentation in configuring the loganalytics space and have contacted azure support, who confirmed everything to be well configured on azure side and they suggested turning to grafana support/community for help.

2

Really hoping someone would point me in the right direction

3

Hello! Not sure if this issue has been resolved. Would you mind going into the configured variables (you can get here by clicking on the gear icon and clicking on variables)
image

Can you confirm that the value for the workspace variables is Workspaces($sub) seems like the workspaces variable might have been miss-configured.

One last question, where did you import this dashboard from?