Hey all,

I'm trying to create a connection from Microsoft Power BI to the WinCC Process archives with the "WinCC OLEDB Provider". But still no luck getting it to work.

I know how to make a connection in VBA with Excel but from PowerBI?

Dit someone already did this? If so, what is the trick?

PS: Microsoft PowerBI desktop is free to test.

https://powerbi.microsoft.com/en-us/

Yes, already seen it and used it to get data into Excel. Worked fine.

Next stop is MS Power BI.

Finally got it working!

I had the 64 bit version of PowerBI installed. Removed and installed the 32 bit version.

Help to others. Here is the "Power Query" in PowerBI to get the process values of 4 tags from WinCC Professional v15.1 Upd3: 

= OleDb.DataSource("provider=WinCCOLEDBProvider.1;data source=ECJ-P010\WINCC;catalog=CC_HMI_7HI6_19_10_14_09_57_05R;mode=Read", [Query="TAG:R,(1;2;3;4),'0000-00-00 00:30:00.000','0000-00-00 00:00:00.000'"])

TIP!

1. Do not use spaces in the Query.
2. Catalog name in example is for WinCC Professional. In WinCC v7+ use "CC_ExternalBrowsing".

Now another issue in WinCC Professional, because you don't have/need the "CC_ExternalBrowing" dababase you link to the actual runtime DB. But it changes it's name each time the project is compiled. This is an issue off-course. Created another question about that: https://support.industry.siemens.com/tf/ww/en/posts/fixed-runtime-database-name/221892/?page=0&pageSize=10#post880541 

Old thread, but I want to add, that it worked for me also with Power BI 64bit and WinCC V8.0.

Greetings,

BBritten