Unable to use Synapse workspace features in Synapse Link for Dataverse when Synapse network is in private mode

Question

Hi Team, We are using Synapse Link for Dataverse for syncing data from d365 to ADLS Gen2, which can be used for analytics in ADLS Gen2. As our Synapse analytics environment network is publically disabled and using private end points, we cannot enable the synapse analytics environment while creating synapse link in Dataverse. Due to which we will not be able to use out of box features provided by MS when using synapse analytics. When we enable the synapse analytics in the Synapse link and make use of spark pool, it automatically created the lakehouse database in synapse analytics, tables and also stores the data in delta format in the ADLS Gen2. However if we don't use this option, as we have created private connectivity between Dataverse and ADLS Gen2, the data get stored in the CSV format. Is there any alternative approach to use the capabilities of Synapse analytics in the synapse link for Dataverse when using Synapse analytics in the private mode?

Answer 1

Hello Sriram M,

Welcome to the Microsoft Q&A forum.

As of today, there is no way to implement private networking with Azure Synapse Link for Dataverse. However you an use the feature "Access firewalled storage accounts using a trusted app".

This feature allows you to create a trusted app that can access your firewalled storage account. You can then use this trusted app to access the storage account from your Synapse workspace.

Reference document:

https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/data-platform/access-firewalled-storage-accounts-using-trusted-app

I hope this answers your question.