Can semantic model in Fabric connect directly to the Azure Synapse Dedicated SQL Pool

Hi KV_ ,

When setting up the semantic model you can use the SQL connection string to connect to your Azure Synapse Dedicated SQL Pool. This should not alter anything in your current setup. The Fabric environment is built on and can be accessed from the current Power BI service UI.

If you would like to explore options of getting the data into Fabric, Microsoft recently released a migration tool to assist in migrating Synapse Dedicated Pools to Fabric Warehouse. The documention for this tool can be found here: https://learn.microsoft.com/en-us/fabric/data-warehouse/migrate-with-migration-assistant

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Hi KV_,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you SamsonTruong, for your response regarding the issue.

You can  set up a semantic model in Microsoft Fabric that connects directly to your existing Azure Synapse Dedicated SQL Pool without moving or importing the data into OneLake.

To do this, ensure you configure your semantic model using DirectQuery or a live connection to your Synapse Dedicated SQL Pool. This way, the semantic model queries data live from Synapse, keeping your current data source intact and avoiding any data duplication. Your reports in Fabric will then connect to this semantic model just like they do today in Power BI.

Fabric’s environment integrates well with the Power BI service UI, so you should feel comfortable managing your reports there.

If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance.