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.
5,294 questions
How to read CRM Dataverse option set to ADLS using synapse analytics mapping dataflows?
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
What are the necessary steps to follow to process the CRM Dataverse option set to ADLS using synapse analytics?
When we are using data flows, we are getting the following error.
Error code
DFExecutorUserErrorTroubleshooting guide
Activity ID
b561527e-2137-489a-82f6-96bc66046730
Details
at Source 'Optionset': PersistenceLayer | Could not read '/StateMetadata.csv' from the 'cdm' namespace. Reason 'shaded.msdataflow.com.microsoft.commondatamodel.objectmodel.storage.StorageAdapterException: There is no resource found for /StateMetadata.csv' | loadDocumentFromPathAsync | /StateMetadata.csv
{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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,356 Reputation points2023-08-14T20:25:34.7133333+00:00 Hello @Rajesh Venkata Kona (Capgemini Singapore Offshore) Welcome to QnA forum,
Thanks for reaching out on this scenario. Few troubleshooting steps i hope you have already went through..- Is this the first time error encountered? or does this work before and failing now?
- file '/StateMetadata.csv' exists in the 'cdm' namespace,
- the file '/StateMetadata.csv' has the correct permissions.
- Make sure that the data flow is pointing to the correct ADLS account.
We can also try creating a new data flow and configuring it to read the option set data from CRM Dataverse and write it to ADLS. This can help to isolate the issue and determine if it is related to the data flow configuration or the data itself.
What is the document which you have followed?
-
Anonymous
2023-08-16T04:48:49.6+00:00 Thanks for the update, Satish.
Please provide the details ASAP. Which will help on the implementation.
-
Anonymous
2023-08-17T04:14:13.3666667+00:00 Thanks for the update Satish.
We followed the below link-
We are following the below steps in mapping data flows in synapse pipeline.
- We selected the following option in source settings -
Source type - inline
Inline Dataset Type - Common Data Model
Selected the required linked service.
- Source Options.
Select Metadata format as 'model.json'
select the root location
select the entity details.
- Select the schema options as 'Allow schema drift '.
- Go to Data preview. We are getting the error.
- How to migrate the power automate CRM optionset metadata from dataverse to ADLS? Could you please suggest?
-
Anonymous
2023-08-22T04:58:54.0233333+00:00 Can anyone help on this? This is a priority.
Thanks,
-
QuantumCache 20,356 Reputation points
2023-08-29T06:25:04.2133333+00:00 Hello @Rajesh Venkata Kona (Capgemini Singapore Offshore) We need a deeper investigation with regards to your scenario. Could you please open an Azure Technical Support ticket if you have a support plan? If you need any help in that matter please do let me know.
Sign in to comment
Sign in to answer