Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.