Problem with ODBC connection to SAP

Question

Hi,&nbsp;I have an ODBC connection (system dsn) with the CData driver for SAP R3. The connection test works for me and if I try to connect to this connection from a tool like WinSQL I can access the data without problems.&nbsp;Once the connection is verified, if I try to make the connection from PowerBI (using the ODBC connection) the system connects correctly but when loading the data it shows the following error message.I have added the path where the dll files are in the global variables of the PATH environment. However, it still shows that error. The strange thing is that from the other applications I can access without problems.&nbsp;Could someone tell me if I have to do something else from PowerBI so that I can locate that file and load the data model?&nbsp;

nitrox · Accepted Answer

Hi,&nbsp;I have already solved this case in another way. The problem was that the system required that the SAP DLL files were in the path c:\windows\system32\. Once the change was applied, the ODBC connection on the PowerBI side works correctly.&nbsp;Finally, I use an ODBC connection (not the standard connector that PowerBI incorporates for SAP).&nbsp;Many thanks!!!

Forum Discussion

Related content

Problem connecting to report server

Web V2 connection problem

Gateway Connection Problem

Logic problem?

Fabric warehouse connections problem