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,597 questions
Azure synapse link creates model.json with no partitions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 20%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
Dipo Onibile
0
Reputation points
Hi,
I am following this link below to copy dataverse data to Azure SQL DB using azure data factory pipelines. The model.json file created by my synapse link for dataverse is correctly creating the schema and attribute names for all the tables/entities. However, no data is coming across in the pipeline because the model.json file is not updated with partition location for any of the entities.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth 7,825 Reputation points Microsoft Vendor2024-06-26T04:37:58.38+00:00 Welcome to Microsoft Q&A platform and thanks for posting your question.
It seems like you’re facing an issue with the
model.jsonfile not being updated with the partition location for the entities. This could be due to formatting issues of the partition location path in themodel.jsonfile. Here are the steps you can follow to fix this issue:- Open the
model.jsonfile in a text editor. - Find the
partitions.Locationproperty. - Change
"blob.core.windows.net"to"dfs.core.windows.net". - Fix any
"%2F"encoding in the URL to"/".
Please note that the
model.jsonfile in a Common Data Model folder describes the data in the folder, metadata and location, as well as how the file was generated and by which data producer. Thepartitions.Locationproperty in themodel.jsonfile is crucial as it provides the location of the data files.If you continue to face issues, I recommend checking out these resources:
- Copy Dataverse data into Azure SQL - Power Apps | Microsoft Learn
- Export Dataverse data to SQL using Data Lake and ADF
- Common Data Model format - Azure Data Factory & Azure Synapse
These resources provide detailed steps on how to copy data from Dataverse to Azure SQL using Azure Data Factory and might help you troubleshoot
Hope this helps. Do let us know if you any further queries.
- Open the
-
phemanth 7,825 Reputation points Microsoft Vendor
2024-06-28T06:08:57.3866667+00:00 @Dipo Onibile We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment