Implementation 2.0 SAP Connector

[Anonymous]

Hi,

I have been testing the new Implementation 2.0 SAP Connector against our SAP BW system explained here:

https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector

It works beautifully when using Desktop with significantly lower memory usage and faster execution than the 1.0 version.

However, when I publish to the PBI Service and try to use our gateway to refresh the data, I get the following error:

Do I have to install something on the VM running the gateway?

I tried to install the SAP Connector for Microsoft .NET 3.0.20.0 for Windows 64-bit (x64) as zip file (7.180 KB), January 16, 2018 on the VM, but it still doesn't work.

[S_loke · Accepted solution]

Just an update that with June deployment of the gateway, this is now working as expected with the reports being to be refreshed on PBI service

[Anonymous]

Just wanted to add that If it is just SAP (HANA) tables you are after or sub sets of it based on a SQL filter you may want to try the shareware tool ExtracTable at sourceforge.net instead of developing more complex .Net rfc connectors yourself. Call ExtracTable in commandline mode to make it start automatically. Works here.