topic Dataflow Destination to Fabric SQL Database Not Showing in SQL database

Dataflow Destination to Fabric SQL Database Not Showing

Gmeza — Mon, 23 Dec 2024 14:35:34 GMT

I have enabled SQL Database features through the Admin portal of Fabric and successfully created a new SQL database. However, when I try to load data using Dataflows Gen2, I do not have the specific option to load it to the database, only the option to do Lakehouse, Warehouse, Azure SQL, and KQL. Am I missing some type of setting or something?

Re: Dataflow Destination to Fabric SQL Database Not Showing

Anonymous — Tue, 24 Dec 2024 01:55:57 GMT

Hi Gmeza

Please refer to the following post:

Load data with Dataflow Gen2 into SQL database - Microsoft Fabric | Microsoft Learn

Make sure you meet these prerequisites:

This is my test result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Dataflow Destination to Fabric SQL Database Not Showing

Gmeza — Tue, 24 Dec 2024 02:38:45 GMT

Thank you for your reply, Jayleny. After successfully confirming all prerequisites had been met, I followed the link's instructions but still did not see the option for a SQL database destination.

I can run SQL queries on the database, and evene the Sample Data was imported correctly. But no dataflow update. What am I missing?

Re: Dataflow Destination to Fabric SQL Database Not Showing

Gmeza — Tue, 07 Jan 2025 17:44:16 GMT

Today, the options to Extract/Load to a Fabric SQL Database became available to me. I didn't do anything different (to my knowledge). I suspect this was just something on the backend of my account. I guess it just needed time to appear.

Re: Dataflow Destination to Fabric SQL Database Not Showing

dlevy — Tue, 07 Jan 2025 18:23:55 GMT

Hi Gmeza - There were some regions that experienced delayed rollouts of some features. Those should be clearing now. Apologies for the inconvenience!