SAP Message Server on DataMart complains about missing driver

[ToreArneson]

Importing data from SAP Message Server into a Power BI DataMart proves to be a challenge. It usually works, but quite often complains that the driver is missing, and I really ought to install it. This is an obviously difficult, given that this all runs on the service. The specific error is:

"This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'SAP .NET Connector 3.0.0.42': https://go.microsoft.com/fwlink/?linkid=872300"

Can you please advise on steps we can take to ensure that we can load data to our datamart without encountering this issue?

Thanks,

Tore 

[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).

[Anonymous]

Hi @ToreArneson 

Did you install the .NET in your local ? You can install the package and then try to import data .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ToreArneson]

Yes, the .NET-driver is installed locally and works great. It also works via the Data Gateway. However, the point of the DataMart would be to do the extraction directly there, hence the frustration of being asked to install a driver.