Forum Discussion
Solved
Siemens WinCC OLE DB Provider
Hey all, We want to create reports from process archives generated by the SCADA system "Siemens WinCC". These are values that are stored in a SQL-database but in segmented and compressed form. To...
Figured it out (sort off)
I had PowerBI x64 installed and my Excel is 32. Removed PowerBI and installed the 32bit version. Guess WinCC only works with 32 bit
Now it works.
Did some more research but still no luck in Power BI.
In Excel I could create a connection using "Power Query" with following:
let
Source = OleDb.DataSource("provider=WinCCOLEDBProvider.1;data source=ECJ-P010\WINCC;catalog=CC_HMI_7HI6_19_10_08_16_05_47R;mode=Read", [Query="TAG:R, (1; 2; 3; 4), '0000-00-00 00:30:00.000', '0000-00-00 00:00:00.000'"])
in
Source
Also figured out how to make this exactly in PowerBI but I still get the error: 'The 'WinCCOLEDBProvider.1' provider is not registered on the local machine.'
How come Excel has no issue but PowerBI can't connect?
Any thoughts?
Figured it out (sort off)
I had PowerBI x64 installed and my Excel is 32. Removed PowerBI and installed the 32bit version. Guess WinCC only works with 32 bit
Now it works.