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

[KV_]

Hello Team,

I have developed a report using Power BI, and the semantic model currently retrieves data from the Azure Synapse Dedicated SQL Pool. I would like to migrate my report to Fabric while keeping my data source as the Synapse Dedicated SQL Pool.

I am exploring options to create a semantic model in Fabric that can pull data from the Azure Synapse Dedicated SQL Pool without transferring the data into OneLake. Additionally, I want to ensure that the reports remain connected to this semantic model, which references the Azure Synapse Dedicated SQL Pool.

[SamsonTruong · Accepted solution]

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

[v-hjannapu · Accepted solution]

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.

[v-hjannapu]

Hi @KV_ ,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @KV_ ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank You.

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @KV_,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you

[SamsonTruong · Accepted solution]

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