Unable to connect to SAP Table Application Server

[FrancescoPwc]

Hello, we are trying to configure connectivity to SAP using Fabric Data Factory.

We have configured a Data Gateway onprem that has connectivity and the required libraries to connect to SAP. We are using an account with the required permissions, but when trying to configure the copy data, at the second step, when it should list the tables it gives an error:

The operation failed, detailed error: An internal error has occurred. Please retry the operation at a later time. 
If the issue persists, please contact Microsoft support for further assistance. 
Activity ID: b42d66e3-ae5b-4781-8d40-6e6a22ea43ca

We are in contact with Infra and SAP Team. Every one sees the connection is being made and shouldn't be a network or privilege issue. Any suggestions?

[AndreaPwC]

Hi everyone,

just a quick update to let you know that we've attempted a new method of connecting to SAP, but we're currently experiencing some issues. I'm sharing the issue link here:

https://community.fabric.microsoft.com/t5/Dataflow/Issue-Accessing-OData-Service-Root-from-Fabric-to...

Thank you!

[v-pagayam-msft · Accepted solution]

Hi @FrancescoPwc ,

Thank you again for sharing your experience.You have been to spend that much time trying to find out the connector is not available yet. Your feedback truly helps us understand where the gaps are.

I would also recommend sharing this in the Fabric Ideas forum. It is a great way to bring more visibility to the issue, and where others vote on it, it helps push the topic up in priority .

And if you do find a workaround that fits your setup, we would really appreciate it if you could share it here too .I am sure it would help others facing the same challenge.

Thank you for your cooperation.Have a great day!

[v-pagayam-msft]

Hi @FrancescoPwc ,

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum ,we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[v-pagayam-msft]

Hi @FrancescoPwc 
Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[AndreaPwC]

Hi @v-pagayam-msft ,

I'm Andrea, @FrancescoPwc 's colleague.

Looking at the official documentation (https://learn.microsoft.com/en-us/fabric/data-factory/connector-parity), we found out that the SAP Table connector is not currently available in Fabric Data Factory, but only in Azure Data Factory.

Could this be the reason for the malfunction?

Reagrds,

Andrea

[v-pagayam-msft]

Hi @AndreaPwC ,

Thank you for sharing the information and updating us!
The SAP Table connector is currently available only in Azure Data Factory, and not yet in Fabric Data Factory. Because of this, you are encountering the "internal error" when trying to list tables.

As a next step, I suggest considering supported alternatives like connecting via SAP HANA, ODBC if they are compatible with your SAP system. Alternatively, you could continue using Azure Data Factory to extract the data and then move it into Fabric as if needed.

Hope this helps.If so,consider accepting it as solution.

[v-pagayam-msft]

Hi @FrancescoPwc ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.

[FrancescoPwc]

Hi, we do not have Azure Data Factory, so we need to find a workaround in Fabric. We will check possible solutions next week, in order to be able to comment here the correct workaround for the connector stil not being available in Fabric. Thnks

[v-pagayam-msft]

Hi @FrancescoPwc ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!

Thanks for sharing the details and screenshot.Below steps might help you to resolve the issue:

• Ensure the SAP .NET Connector (NCo) is installed on the same machine as your on-premises data gateway, and that sapnco.dll and sapnco_utils.dll are present in the system PATH.
• Confirm weather gateway is online, up-to-date, and can reach the SAP server.
• Double check that the SAP user account has access to essential function modules.
• Retry the operation after a few minutes, sometimes these internal errors are transient and clear up on their own.
  

Please refer here for more information:
https://learn.microsoft.com/en-us/azure/data-factory/sap-change-data-capture-prerequisites-configura...
https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-sap 

If the solution meets your requirement,consider accepting it as solution.

Regards,
Pallavi.

[databryan-os]

Hi Microsoft Support team,

Thank you for confirming that the SAP Table connector is not yet supported in Data Factory for Fabric and currently exists only in Azure Data Factory. However, the connector still appears in the Fabric Data Factory copy‑data wizard and allows us to enter credentials before failing with the “internal error” shown above.

• Expectation gap – Because the connector is visible in Fabric’s UI, we assumed it was in General Availability or at least Public Preview for Fabric. The official connector‑parity table, though, lists SAP Table as unsupported (“N”) in Fabric while showing it as available in ADF (✓/-). Microsoft Learn

• Current impact – The misleading presence of the connector caused avoidable troubleshooting effort on our side (gateway checks, NCo libraries, SAP role reviews, etc.) before we learned that the feature itself is not yet enabled.

• Questions

  1. Why is the SAP Table connector surfaced in the Fabric UI if it is not yet functional?

  2. What is the planned roadmap or ETA for SAP Table support in Fabric Data Factory?

  3. Could the documentation and/or UI be updated to indicate “coming soon” (similar to other preview labels) so that customers can plan integrations accordingly?

Any visibility you can provide on status and timelines would help us decide whether to wait for native support or to invest in the suggested work‑arounds (SAP HANA, ODBC, or staging through Azure Data Factory).

Thanks in advance for the clarification.

Best,

Bryan

[FrancescoPwc]

I couldn't have explained it better! Same has been for us, many hours if not days trying to make it work with involvment on multiple sides (infra, SAP, Fabric teams). It should have been clear from the beginning that the connector wasn't yet available... Thanks