'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Why Dataverse Multi-Select Columns Are Missing in Azure Data Factory
Question details
The user is unable to find or preview multi-select Dataverse columns when connecting an entity through an Azure Data Factory linked service.
- Product
- Azure Data Factory
- Device & OS
- not provided
- Scenario
- Previewing Dataverse entity schema and data via an Azure Data Factory linked service.
- Observed behavior
- Multi-select (Choices) columns are entirely missing from the schema or table preview within Azure Data Factory.
Ensure you have the appropriate permissions in Azure Data Factory and understand that the native Dataverse connector has specific schema limitations regarding complex data types.
Consult Azure Data Factory Forums and Documentation
Because this is an Azure Data Factory and Dataverse connector limitation rather than a standard Office application issue, specialized engineering support is required.
The Azure Data Factory (ADF) Dataverse connector natively struggles to expose multi-select choice columns because they are stored as complex array types rather than flat strings. Since this issue does not involve Microsoft Word or standard Office applications, standard Office troubleshooting will not resolve it.
Navigate to the official Microsoft Q&A or Azure Community support forums in your web browser.
Create a new thread tagged with 'Azure Data Factory' and 'Dataverse' to get specialized guidance on supported workarounds for complex data types.
Use a FetchXML Query Workaround
Bypass the native table preview limitation by using a custom FetchXML query in your ADF Copy Activity.
Looking for a Lightweight Word Processor?
While Azure cloud data issues require specialized engineering support, if you originally sought help for standard documentation tasks and need a fast, reliable, and free alternative to Microsoft Word, consider WPS Office.
- 1. Download the Installer: Visit the official WPS website and click the 'Download' button to get the free installer.
- 2. Install the Suite: Run the downloaded executable file and follow the simple on-screen instructions.
- 3. Open and Edit Documents: Launch WPS Writer to seamlessly open, edit, and save your existing Microsoft Word documents without formatting loss.
Frequently Asked Questions
Why do multi-select columns not show up in ADF Dataverse previews?
Multi-select columns (Choices) are complex data types. The standard Azure Data Factory Dataverse connector maps flat schemas and does not automatically flatten or parse these arrays in the basic table preview.
Can I use OData queries to get Dataverse choice columns in ADF?
Yes, you can use the OData connector or a Web Activity to hit the Dataverse Web API as an alternative to the native connector, which allows you to fetch the underlying integer values or formatted text of choice columns.
Does Microsoft Word integrate directly with Azure Data Factory?
No, Azure Data Factory is an enterprise cloud data integration service. It does not integrate natively with desktop word processors like Microsoft Word.
