Skip to content

Instantly share code, notes, and snippets.

@WilliamBerryiii

WilliamBerryiii/query.sql

Last active January 4, 2017 23:24
Show Gist options
  • Save WilliamBerryiii/c3d6e4e87d4507ffe02cb6327eb31ab3 to your computer and use it in GitHub Desktop.
Save WilliamBerryiii/c3d6e4e87d4507ffe02cb6327eb31ab3 to your computer and use it in GitHub Desktop.
Download ZIP
Azure IoT Hub Modbus Demo
Raw
query.sql
SELECT
Cast (DataTimestamp as datetime) as datetimestamp,
device_type,
(Cast(address_30002 AS float) / 65535 * 100) as cnt
INTO
[power-bi]
FROM
[iot-hub]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment