Using SAP BW OLEDB provider

[KonstantinS]

Hi everybody!
I have an Excel file (32 bit)  connected to the SAP BW instance via SAP BW OLE DB Provider.
I'm trying to establish the same connection in PBI Desktop (on the same PC), using the same connetion string (Provider=MDrmSap.2;Data Source=TNP;Location="";Mode=Read;Extended Properties="SFC_CLIENT=100;";Initial Catalog=Z05M04;MDX Compatibility=1).
But in PBI Desktopx64 I have a message that "Provider MDrmSAP.2 does not registerid on this PC"
And in PBI Desktopx32 - "OleDb.DataSource does not currently support multidimensional data sources"

Any Ideas?

Thank you in advance!

[v-piga-msft]

Hi @KonstantinS ,

It seems that you want to get data from SAP BW in power bi desktop.

Which connector do you use? The direct SAP BW connector or ODBC connector?

In addition, have you install the Provider MDrmSAP.2?

For reference, you could follow this document to get data from SAP BW.

Best  Regards,

Cherry

[KonstantinS]

I'm trying to use the SAP BW OLE DB Provider. Of course it is installed and works well with Excel on the same PC. 

I Know about the SAP BW .net connector and I'll try it soon, but I want to understand why OLE DB variant does not work (it  does not work "by design" or I'm doing something wrong) 

[KonstantinS · Accepted solution]

So, the solution is to ue SAPBW .net connector - it works.