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 read out the values we need to use "WinCC OLE DB Provider" which is installed by the Siemens software. This works fine from for example the "SQL Import/Export wizard". There you can select it through a dropdown and do the rest. I also got it working in Excel trhough a "ADODB.Connection" in VBA.
Now I'm wondering how I can make PowerBI connect through this "WinCCOLEDB Provider"? When I try through an "OLE DB" connection, I can't select it. When I type it myself, it gives the error that the provider is not registered.