Forum Discussion

ToreArneson's avatar
ToreArneson
Frequent Visitor
2 years ago

SAP Message Server on DataMart complains about missing driver

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 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      ToreArneson
      Frequent Visitor
      2 years ago

      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.

  • labrosstr's avatar
    labrosstr
    Frequent Visitor
    2 years ago

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