Forum Discussion
Payload Conversation error reading from Fabric SQL or Lakehouse
Hi I'm the admin in a workspace and when I provision a native SQL db in Fabric and try to read from it in a pipeline, I can't. However, I'm able to read and write from within the SQL editor just fine...
Hi User_thename ,
Seems like its a connectivity issue which is specific to the pipeline execution environment, not your SQL db or permissions.
If you're using a gateway, verify that it supports TDS over port 1433.
Try to use explicit cloud connection, map your Fabric SQL db explicitly in the pipeline settings.
If your pipeline references a staged query or intermediate Lakehouse, try simplifying it to a direct read/write operation.
If you are still getting an error even after following these checks, try raising a support ticket.
How to Create a Support Ticket
Hope this helps!