Getting Error while pulling data from fabric lakehouse table: Error code 21446 Details Invalid table

Hi Sachin_Patel07,

You can solve the issue in two ways. The first option is to create a notebook in your Fabric workspace, select only the required columns from the table (excluding problematic ones like _change_type), and then write the data directly to your ADLS Gen2 storage. For this, you’ll need to set up the connection to ADLS using the proper credentials or linked service. The second option is to create a new clean table inside the Lakehouse with only the needed columns, then use your Synapse pipeline’s Copy Activity to pull data from this new table. Both options work the first gives more flexibility, while the second allows you to keep using your existing pipeline setup.

Thanks & regards,

Prasanna Kumar