Is it possible to use Synapse link to retrieve attachments from Dataverse?

saurabh 356 Reputation points


I noticed that currently Synapse link for dataverse does not sync attachments from dataverse. The only way to get attachments is to make Dataverse REST API calls. Is there a way to use synapse link to get the attachments as well ?

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,678 questions
0 comments No comments
{count} votes

Accepted answer
  1. phemanth 8,645 Reputation points Microsoft Vendor

    @saurabh Welcome to Microsoft Q&A platform and thanks for posting your question.

    You're right, currently Azure Synapse Link for Dataverse doesn't synchronize attachments by default. While there's no direct way to achieve it through Synapse Link itself, here are your options:

    The primary function of Azure Synapse Link is to enable near real-time analytics on operational data by creating a link between Dataverse and Azure Synapse Analytics1. It allows you to manage and monitor your Dataverse tables included in the Azure Synapse Link.

    Dataverse REST API Calls: As you mentioned, this remains the primary method for retrieving attachments. You can leverage Power Automate or custom code to interact with the Dataverse Web API and download attachments based on your needs.

    Consider Alternative Storage: Explore storing attachments in Azure Blob Storage instead of directly within Dataverse. Synapse Link integrates seamlessly with Azure Blob Storage, allowing you to synchronize data and access attachments efficiently. This approach involves modifying your data model to reference attachment information stored in Blob Storage.

    Here are some resources that might be helpful:

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

0 additional answers

Sort by: Most helpful