How to query data from Aspen IP21 using ODBC in Real Time.

[srg231985]

Hello Team,

I am trying to query data from Aspen IP21 using ODBC in Real Time. My below query works perfectly fine & it fetches data between a particular time stamp. Now i want to make timestamp value dynamic so it reference value based on real time. In current query it's static. 

How can i make time stamp dynamic value based on real time value or atleast user entered value.

= Odbc.Query("dsn=IP21-XXX", "select *from ip_analogdef where name='TIXXX/DACB.PV' and ip_trend_time between timestamp'2020-05-06 00:00:00' and timestamp'2020-05-06 01:00:00';")

[v-eachen-msft · Accepted solution]

Hi @srg231985 ,

Power BI Desktop doesn't support real-time refresh.

Here is a PowerShell script that opens Power BI Desktop and sends a key to the Refresh button. 
https://prologika.com/automating-power-bi-desktop-refresh/

Under normal circumstances, you can create streaming dataset in Power BI Service and use Rest API to push data to streaming dataset. Here is the document for your reference.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming