The other day I posted about the significant performance difference between SQL DAS (OLEDB) vs SQL DAS (RTQP). I see many older client solutions are based on SQL DAS (OLEDB) where query
In this post, we will play around with the idea of implementing a modern data lake with good old OSISoft/AVEVA PI environment on the backend. After some poking around, I was able
More
The other day I posted about the significant performance difference between SQL DAS (OLEDB) vs SQL DAS (RTQP). I see many older client solutions are based on SQL DAS (OLEDB) where query
More
I made a post couple days back on a solution I recently implemented where I integrated data from 8 different OSIsoft PI/AF servers into a single Power BI report. This solution eliminated
More
I made a post couple days back on a solution I recently implemented where I integrated data from 8 different OSIsoft PI/AF servers into a single Power BI report. Although I implemented
More
Sharing this solution I designed few months back. The solution implements a financial reporting dashboard on Power BI for a client which looks like a normal PBI dash at the first glance.
More