Forum Discussion
Dataflow connection error to SQL Database (preview) or Lakehouse
The Dataflow indicates a successful connection to the SQL Database (preview) or Lakehouse; however, no data is being transferred. Despite the connection status showing as active, the data does not appear to be flowing from the Dataflow to the target destination.
Could someone advise on potential solutions or troubleshooting steps for this issue? Thanks.
Open Dataflow Editor → Check the preview of your final query.
Ensure rows are returned.
Enable Load to Destination:
Right-click the final query → Click “Enable load” (if not already enabled).Check Schema Compatibility:
Make sure column names and data types match the destination (SQL DB or Lakehouse).Test with a New Table:
In output settings, write to a new table name to avoid conflicts.Re-authenticate Connection:
Go to Manage connections → Click Edit icon → Re-authenticate SQL or Lakehouse connection.Review Refresh History:
Go to Dataflow settings → View refresh history → Look for errors or “0 rows written.”If no data is showing in the preview, the issue is with the source query or connection, not the destination.
3 Replies
Open Dataflow Editor → Check the preview of your final query.
Ensure rows are returned.
Enable Load to Destination:
Right-click the final query → Click “Enable load” (if not already enabled).Check Schema Compatibility:
Make sure column names and data types match the destination (SQL DB or Lakehouse).Test with a New Table:
In output settings, write to a new table name to avoid conflicts.Re-authenticate Connection:
Go to Manage connections → Click Edit icon → Re-authenticate SQL or Lakehouse connection.Review Refresh History:
Go to Dataflow settings → View refresh history → Look for errors or “0 rows written.”If no data is showing in the preview, the issue is with the source query or connection, not the destination.
Hi js15 ,
May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
Just did, thank you.
