Dataflow Gen2 cannot write to Fabric SQL Database, error says "Data source kind: FabricSql"

Hi tpg0220 ,

1) There seems to no official documentation on the above issue from Microsoft, however, as Fabric SQL DB is authenticated via only OAuth2 and no SPN or workspace identity is supported, hence can cause cross-workspace conenction issue.

You can raise a ticket for this bug to Microsoft once.

Workaround- you can try using Azure SQL DB as your destination and give Fabric SQL DB endpoint -server name and database name. Use Fabric SQL DB T-SQL connection string. You can find it in settings-Connection strings-SQL server format. Authenticate it via Org account or SPN.

This method bypasses FabricSQL connection.

Let me know if the above solution works, else we can use Lakehouse to move the data to Fabric SQL DB.

Let me know if it answers above query.

Thanks

Ati Puri