I’m trying to copy all tables from a SQL Server to Fabric Lakehouse using the Azure Data Factory, already did with with the AWS S3 but with the SQL Server it’s not working. (I know i can use the fabric, but the company prefer ingestion using ADF)
In these configurations i’m just trying copy only one table inside the lakehouse:
When I Click to see the preview data, i can see the values from database:
But when trigger the pipeline, it takes minutes/hours and the activity do nothing, even an error, so I needed to cancel: