Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone,
I am somewhat new to PowerBI and this is my first time posting to this forum so excuse me if I mess anything up but I have used PowerQuery in Excel at an intermediate level for some time now.
I have been having an issue with a query for a bit now that I just cannot figure out. I am trying to connect to data collected by an industrial data historian called IP21. I am using an ODBC connector with a SQL driver made for the historian and created a 32bit data source and am using 32 bit powerbi.
This is what the query should return including the origninal SQL statement:
Using this same statement everything is ok other than it loads infinite null/blank rows and copies the last process value down with it:
Perhaps there is an issue with my SQL statement? I only recently began picking up SQL as I am much more familiar with C++ and VBA.
Any suggestions would be great, and I look forward to what is possible in PowerBI.
Thanks
Could you share all procedure with me that how are you connecting power BI to IP21?
Hi @stewars3
What result do you get if you run the SQL directly against the database?
Regards
Phil
Proud to be a Super User!
Do you mean running the SQL statement in command prompt? I'm not sure I know how to but I'm sure I could somehow figure it out.
I ran the SQL in a command line type program called "Aspen SQLplus" and the results are shown in the first picture. You can see the last point is at 20:10:00 in both but the last Value is repeated for some reason while using PowerQuery.
Thanks
Scott