Dedicated sql pool-->Fabric

Hi Anonymous ,

Since Microsoft Fabric doesn't support direct queries from a Dedicated SQL Pool, it's best to copy or migrate the data into Fabric. This ensures smooth integration and allows you to use shortcuts, Direct Lake, and Fabric's optimized performance features.

Workaround.

If you need to query the data without migration, you can use Spark in Fabric to connect to the Dedicated SQL Pool. However, keep in mind that this isn't an officially supported method and may come with performance limitations.

• For long-term scalability and full Fabric functionality, migrating the data into Fabric is the way to go. If you just need a temporary solution, you can explore using Spark
• If migration isn't an immediate option, Spark might help as a workaround, but for full Fabric capabilities, moving the data is the best approach. Let me know how you’d like to proceed, and I’d be happy to assist.

Thank you to nilendraFabric  & KevinChant  for providing these valuable insights. Your expertise and contribution to our community are  appreciated.

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.