Getting Azure IoT Hub Data into Eventstream/Eventhouse

Mar 31 (edited) • Technical

Hi everyone,

I recently tried to get data from an Azure IoT Hub into Fabric Eventstream. I created a new connection and that works also fine and so on. The challenge comes with different keys (columns) inside the payload.

The use case is that I have messages inside the topic, where the payload contains data like sensor.temperature and another message has sensor.humidity for instance. Now loading the data into the Eventhouse will only store the values of the first column inside the KQL table, and the other columns of the schema remain empty (even when there's data for them, I investigated the messages inside IoT Explorer).

Is there a method to integrate those kind of use cases into eventstream, because it should be a general IoT case having different messages inside one topic. It would be really dumb creating one topic per telemetry.

Hope you understood the problem and I could explain it well. Thanks in advance!

3 comments