cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kibosh Frequent Visitor
Frequent Visitor

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 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. 

 

Any thoughts?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Kibosh Frequent Visitor
Frequent Visitor

Re: Siemens WinCC OLE DB Provider

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.

View solution in original post

2 REPLIES 2
Kibosh Frequent Visitor
Frequent Visitor

Re: Siemens WinCC OLE DB Provider

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?

Highlighted
Kibosh Frequent Visitor
Frequent Visitor

Re: Siemens WinCC OLE DB Provider

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.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)