keithsimpson
Member
Hi All,
Just wondering if anyone has been able to setup a Directquery on Power BI to the historian SQL database.
I have been able to setup a SQL query in Power BI import function and I am able to get all the historian readings for a tag in a given time frame but when it come to Directquery it doesn't like DECLARE statements.
I m hoping to use Directquery so I can setup automated incremental updates. Import function does not support incremental updates.
Thanks
Just wondering if anyone has been able to setup a Directquery on Power BI to the historian SQL database.
I have been able to setup a SQL query in Power BI import function and I am able to get all the historian readings for a tag in a given time frame but when it come to Directquery it doesn't like DECLARE statements.
I m hoping to use Directquery so I can setup automated incremental updates. Import function does not support incremental updates.
Thanks