Forum Discussion
Helper IDataflow connection error to SQL Database (preview) or Lakehouse
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.
Super UserOpen 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.