Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
So, the solution is to ue SAPBW .net connector - it works.
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
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)
So, the solution is to ue SAPBW .net connector - it works.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.