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,660 points
1,265 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. 

I hope I covered all that you asked!

Ready to elevate your data skills? Dive into our Power BI Course Content and embark on a transformative learning journey designed for data enthusiasts, analysts, and business intelligence professionals!

 

answered Aug 1, 2018 by nirvana
• 3,130 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,280 points
962 views
0 votes
1 answer

Azure IoT Hub : Sending messages using Python via mqtt

The thing is that IoT Hub is not ...READ MORE

answered Jan 4, 2019 in IoT (Internet of Things) by Upasana
• 8,620 points
3,771 views
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,250 points
3,830 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,280 points
1,346 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,250 points
1,790 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,280 points
1,039 views
0 votes
2 answers

Azure IoT Hub Operations Monitoring

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

answered Jan 4, 2019 in IoT (Internet of Things) by Varul
• 140 points
1,620 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,130 points
703 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 10, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,539 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP