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,171
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,620
mcole01
M
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
42
kreamsippycup
K
K
How do i download Citect Studio 2018
Hello, i've been at this for months now, i tried creating accounts on the aveva website but it seems to never approve my accounts or at least when...
Replies
3
Views
65
Wasan
Wasan
N
Citect V5.42 and S7 400
Hello, I have a running project on Citect v5.42 and simatic net v6.4 I have created a new spare PC and loaded all software like Citect, station...
Replies
0
Views
72
neeru805241
N
Back
Top Bottom