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.
Community SupportHi 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!!
js15Just did, thank you.