Displaying Table Schema using Power BI with Azure IoT Hub

0 votes
I'm attempting an IoT ecosystem that can serve as a solution for me. So, I have various sensors connected to the Azure cloud and they're using a gateway to send important data in JSON format to the cloud. But now I'm stuck as I have been unable to comprehend how the JSON schema work with Event Hubs to produce and display information on PowerBI. Is it possible for me to create the schema and send it to PowerBI first and then, get it connected to my devices?
Aug 1, 2018 in IoT (Internet of Things) by Bharani
• 4,550 points
79 views

1 answer to this question.

0 votes
Answering your first question, Event Hubs are what ingest data into the Azure cloud. Now, lets talk about the gateway you're using as depending on whether your gateway can do a RESTful call to the Event Hubs right at the point of entrance, then the data will reach the Event Hubs and will get stored temporarily for whatever period os retention has been specified. These data are then handed over to the stream analytics of Azure IoT Hub where it is analyzed and processed to serve as the various outputs that any user could demand. Now, you could use one of these outputs and direct it to a Power BI dashboard so that it stays connected to the Power BI automatically for all further operations. You can authorize the Power BI dashboard with any organizational account, the lack of which will need you to register your domain with the Azure Active Directory. And since, the JSON format itself is a description of the data table schema used by Power BI, it will follow the same order of going through the Event Hubs to the Stream Analytics to Power BI or in the same manner as the first JSON package gets circulated in. This essentially is the schema that gets fixed by your first package which the rest of your data getting streamed will also follow. The order and format will remain same throughout. And, if you're looking to change the schema later, you could do it with the Power BI REST API. Refer to the following links for alteration of the schema:
https://docs.microsoft.com/en-us/rest/api/power-bi/
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard

I hope I covered all that you asked!
answered Aug 1, 2018 by nirvana
• 3,060 points

Related Questions In IoT (Internet of Things)

0 votes
1 answer

Control LED Blinking Using Java in Azure IoT Hub

Your description of what you did is ...READ MORE

answered Sep 5, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
127 views
0 votes
1 answer
0 votes
1 answer

Testing if messages from my Device is reaching the Azure IoT Hub?

Download the Device Explorer open source tool ...READ MORE

answered Aug 10, 2018 in IoT (Internet of Things) by DataKing99
• 8,130 points
552 views
0 votes
1 answer

Create Azure IoT using ARM Template in Azure

It is not recommended to deploy the ...READ MORE

answered Sep 5, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
167 views
0 votes
1 answer

How to use the data I receive from Azure IoT Hub?

The payload you receive will be a ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by DataKing99
• 8,130 points
85 views
0 votes
1 answer
0 votes
1 answer

Azure - What service to use for Arduino data (iot)

That's because the two services do completely ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
88 views
0 votes
2 answers

Azure IoT Hub Operations Monitoring

Hi, Can you tell which device you ...READ MORE

answered Jan 4 in IoT (Internet of Things) by Varul
• 140 points
176 views
0 votes
1 answer

Sample Program for using IoT Hub DM API

That's because the DM additions are placed ...READ MORE

answered Aug 28, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
26 views
0 votes
1 answer

Display time in a Windows Core IoT app with a clock!

It is possible, but you should understand ...READ MORE

answered Jul 9, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
99 views