Forum Discussion
Solved
Powerbi Intergration with SAP
Good day, I've installed the SAP . NET Connector 3.1 NCo. Up until the stage where i have to load the data or transform the data, i receive this error on most of my data sources. Please assist. ...
Hi it is resolved thanks. It was an authorization issue from the security teams side.
Hi riaankotze10,
Firstly you need to ensure this dll camo from SAP NCo 3.1 package. They hav e a typical installation path:
C:\Program Files\SAP\SAP .NET Connector 3.1\ or
C:\Program Files (x86)\SAP\SAP .NET Connector 3.1\
(depending on architecture).
Next Steps
- Download and install SAP NCo 3.1 from SAP Marketplace (ensure you have authorisation).
- Confirm that:
- sapnco.dll and sapnco_utils.dll are in the correct folder.
- The folder is added to the PATH environment variable.
- Restart Power BI Desktop after installation.
Why this matters
Power BI uses these DLLs to establish RFC/BAPI communication with SAP. If they are in the wrong directory or not registered, the connector will fail during data load or transformation.
If this answer was helpful in any way, I would be pleased to receive a 👍, as well as the satisfaction of seeing a DAX measure work for the first time without needing yet another FILTER.
Please mark it as the accepted solution. This helps other community members find the quickest path and saves them from another endless loop 🌀.
Please mark it as the accepted solution. This helps other community members find the quickest path and saves them from another endless loop 🌀.
How do i know if it is in the correct folder? When we installed it, the installer display did not provide me with to install it in GAC.
I think i really need a teams session - to have you on a call as well as our IM services...