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

Sriram M 0 Reputation points
2024-06-25T06:40:07.63+00:00

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?

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,408 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,612 questions
Dynamics 365 Training
Dynamics 365 Training
Dynamics 365: A Microsoft cloud-based business platform that provides customer relationship management and enterprise resource planning solutions.Training: Instruction to develop new skills.
67 questions
Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
188 questions
Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
15 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee
    2024-06-25T18:04:00.57+00:00

    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://video2.skills-academy.com/en-us/power-platform/release-plan/2023wave1/data-platform/access-firewalled-storage-accounts-using-trusted-app

    I hope this answers your question.

    0 comments