Welcome to Microsoft Q&A platform and thanks for posting your question.
It seems like you’re facing an issue with the model.json
file not being updated with the partition location for the entities. This could be due to formatting issues of the partition location path in the model.json
file. Here are the steps you can follow to fix this issue:
- Open the
model.json
file in a text editor. - Find the
partitions.Location
property. - Change
"blob.core.windows.net"
to"dfs.core.windows.net"
. - Fix any
"%2F"
encoding in the URL to"/"
.
Please note that the model.json
file 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. The partitions.Location
property in the model.json
file 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.