How to visualize data from iothub in grafana?

Question

How to visualize data from iothub in grafana?

Sai Devaraj Manoharan 40

Hi,

I'm currently working on azure iot hub, I have device in iothub which receives temperature data from esp32 in json format im able to receive it.

To visualize this data previously I used azure stream analytics and power bi

in stream analytics I assigned input as Iot Hub and for output as Power Bi

It worked well I'm able to visualize.

Now, I'm trying the same in grafana. But I'm unable to visualize it.

How to achieve this?

Initially In iothub->monitoring->diagnostics setting - created log analytics workspace but to go further I can't able to.

From grafana side configured and integrated azure monitor successfully. but I'm only able to view the metrics and logs related to azure system such as CPU utilization etc. I need to visualize my temperature data in grafana.

2 answers

Your answer

Answer 1

AshokPeddakotla-MSFT 35,971 Moderator

Sai Devaraj Manoharan Greetings!

There is no direct way to connect Azure IoT Hub to a Grafana dashboard.

You can connect Azure IoT Hub to Grafana dashboard through a VM running the Grafana website.

First connect IoT Hub to Azure Stream analytics and Azure Stream analytics to Azure SQL database from an SQL database. Once data is available you can set it up to see it on a Grafana dashboard.

For more details, please refer connect a Azure IoT hub to the VM running Grafana website and Supported Grafana data sources

From grafana side configured and integrated azure monitor successfully. but I'm only able to view the metrics and logs related to azure system such as CPU utilization etc. I need to visualize my temperature data in grafana.

Please check Monitor your Azure services in Grafana and see if it helps.

Do let me know if that helps or have any further queries.

Sai Devaraj Manoharan 40 Reputation points

2023-12-21T18:31:50.64+00:00
Hi thank you for your response.

I followed the reference you mentioned. I did a small change, it is successful for a moment.

As per the reference I created the SQL database and in stream analytics I gave the output as SQL database, before this I created a table in database using the query.

create table table_name (

data_1 INT, data_2 INT

);

I run the query and I'm able to store data in SQL database.

later I opened grafana and there I added microsoft SQL server plugin, gave all the details for configuration and successfully connected with the sql database.

Then started creating query to read data and it is successful also. but there is no continous changes in the value only the last fetched value is displayed.

After some research I came to know that the table stored only 815 rows i dont know why?. So I used a query to delete all the rows

DELETE FROM Table_name.

After doing this I'm not even able to see the data from stream analytics to database but tested the query in stream analytics job it is working fine. All the credentials username password is correct but unable to fetch data from stream. Even tried to create new table and a new new database still the result is same.

What would be the issue here?
AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2024-01-09T15:16:01.2766667+00:00

Apologies for the delayed response. If you are still blocked, For a deeper investigation and immediate assistance on this issue, please file a support request @ https://aka.ms/azsupt?

Answer 2

Daniel Maxwell 0

The best way is to connect the Azure IoT Hub to Azure Data Explorer and then from there connect Azure Data Explorer to the Grafana ecosystem. We are successful with this and happy for the results. https://learn.microsoft.com/en-us/azure/data-explorer/create-iot-hub-connection https://learn.microsoft.com/en-us/azure/data-explorer/grafana

Share via

How to visualize data from iothub in grafana?

2 answers

Your answer