Home > other >  Routing IoTHub device telemetry messages to storage account and Power BI
Routing IoTHub device telemetry messages to storage account and Power BI

Time:07-17

I am attempting to route device telemetry data for a device connected to Azure IoTHub.

I have defined the custom endpoint in message routing to a storage account with the Encoding format set to JSON and routing query set to true.

This has successfully sent the data to the storage account but the telemetry data in the message body is in base 64 shown below

{"EnqueuedTimeUtc":"2022-07-13T13:03:28.4770000Z","Properties":{},"SystemProperties":{"connectionDeviceId":"SensorTile","connectionAuthMethod":"{\"scope\":\"device\",\"type\":\"sas\",\"issuer\":\"iothub\",\"acceptingIpFilterRule\":null}","connectionDeviceGenerationId":"6*********971","enqueuedTime":"2022-07-13T13:03:28.4770000Z"},"Body":"eyJBY2NlbGVyb21ldGVyIjp7IlkiOi0xNSwiWCI6MTAsIloiOjEwMzZ9LCJ0cyI6IjIwMjItMDctMTNUMTU6MDM6MjguNDAwKzAyMDAiLCJpZCI6IlNlbnNvclRpbGUifQ=="}

Reading the enter image description here

  • Related