Knowledge Base / Version 21 / Client Tools / ODBC Client

Querying the Historian Using Power BI (version 21)

2 yrs ago

Open Power BI and select 'Get data'
Search for 'ODBC' then click 'Connect'

The 'From ODBC' window will appear. Expand 'Advanced options' to type in a SQL query. In this example, we are requesting a daily maximum value over a 1-week span.

select * from data where tag_name like 'Testing.North.Alpha.Random.%'
and time_stamp >= '9/1/2021 00:00:00'
and time_stamp < '9/8/2021 00:00:00'
and aggregate_id = 'Maximum2'
and aggregate_interval = '1.00:00:00'

Click 'OK'.
Another window will appear prompting the user to specify how to connect. Select the 'Default or Custom' tab then click 'Connect'.
A preview window will appear where the user can then 'Load' or 'Transform Data'.