Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using SAP BW OLEDB provider

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

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

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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