How to create powerBi dashboard for multiple devices automatically?

Question

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.

Answer 1

Hello @Pradeep ,

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.