question

Pradeep-7154 avatar image
0 Votes"
Pradeep-7154 asked MayankBargali-MSFT edited

How to create powerBi dashboard for multiple devices automatically?

Hi All,

I need help in creating multiple device dashboard using powerbi.

Let's say i provision a device on azure IOTHub, and after successful registration. Registered device must be populated in power bi dashboard.

azure-iot-hubazure-stream-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @pradeep-7154,

Just checking in to see if the below suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

SandervandeVelde42 avatar image
0 Votes"
SandervandeVelde42 answered SandervandeVelde42 edited

Hello @Pradeep-7154,

PowerBI is a great solution for showing telemetry coming from devices.

The easiest way is to make use of Azure Stream Analytics to send incoming IoT Hub messages to PowerBI.

First, create a Stream Analytics resource and add an input that picks up messages from the IoT Hub.

Next, add an output that is connected to your PowerBI account.

Finally, add an ASA query that handles the messages.

Also, check out this MS Learn module that connects IoT Central to PowerBI. Once those messages are exported to Azure, the solution is compatible.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.