Citect Historian to Power BI

keithsimpson

Member
K
Join Date
Dec 2012
Location
Bathurst
Posts
9
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
 

Similar Topics

S
Citect Historian / Reports Deployment Manager
Hi Everyone, I am using CitectHistorian 4.5 and ı have a problem with deploying the reports. When i click to the Deploy Report in the Historian...
Replies
4
Views
2,182
tragically1969
T
M
Citect / Historian Backfilling Strings
Hi All I've recently been tasked with the implementation and installation of a Historian system into a plant, and I’ve encountered a major issue...
Replies
2
Views
2,631
mcole01
M
S
Citect Web Client - Help
Hello everyone. Could someone please assist me? I am using Citect version 7.2 service pack 5 and Windows 7. I have created a project...
Replies
0
Views
56
Sirwan
S
R
vijeo citect scada
Hello, the system we use is Scada 7.5 series. We have usb key activ now we need additional key to make the system work, how do we solve this...
Replies
0
Views
97
Rashka
R
K
Need Help Modifying Citect Scada Historical Trend Variable Data
So i've been at this for a long while, i have Citect Scada 2018, i have full access to everything but i can't seem to find any option or...
Replies
0
Views
125
kreamsippycup
K
Back
Top Bottom