SAP BW Connector issue

[Schulle]

Last  week I've had a SAP GUI update from Version 7.4 to 7.6.

After this update the SAP BW connector in Power Query in PBI Power Query delivered the following error message:

DataSource.MissingClientLibrary: Dieser Fehler war möglicherweise die Folge von erforderlicher anbieterspezifischer Clientsoftware, die auf diesem Computer nicht vorhanden ist. Zum Herunterladen von Clientsoftware für diesen Anbieter suchen Sie die folgende Website auf, und wählen Sie mindestens die 32-Bit (x86)-Version "SAP .NET Connector 3.0.0.42" aus: https://go.microsoft.com/fwlink/?linkid=872300.
Details:
ClientLibraryName=SAP .NET Connector 3.0.0.42
DownloadLink=https://go.microsoft.com/fwlink/?linkid=872300

Sorry, I've only the error message in German at the moment. In a nutshell: missing libraries for specific appl. software.

I tried to get a fresh reinstall of the SAP .NET Connector (see: https://docs.microsoft.com/en-us/power-query/connectors/sap-bw/sap-bw-troubleshooting#perform-clean-...)

After this reinstall the Power Query editor in PBI client is working again. So far so good.

However, the Power Query editor which can be used/started in Microsoft Excel is still delivering the same error message (see above). I have searched the net for any information about this issue for Power Query in Excel but have not found anything.

Any advice how to solve this?

Thanks in advance

[labrosstr]

I managed to solve this issue by uninstalling the SAP. NET Connector and reinstalling it.

Note that in the installation process, in the Optional setup steps, you need to select the third option:

"Register WMI provider and install assemblies to GAC".

(Maybe the second option "Install assemblies to GAC" works too).

(With the first option "None" I could perform refresh with Power BI Desktop).

[edhans]

You might want to contact SAP. I wonder if they are supporting this update in Excel. It would require SAP to install software/updates in a directory for Excel to access.

[Schulle]

Hi,

thanks for your reply. What I've found out just a few seconds ago. I get the same error message when trying to use the SAP Net Connector in Power Query editor in our PBI Sandbox in Web.

So in the PBI client it works, however if it try to create a data set on the server not. 

[edhans]

I think the path forward is to contact SAP. Sounds like they got Desktop working, but Excel, Power Query Online, etc. are not. That is not an MS issue.