Missing multi-select columns of Data-verse entity, when previewed the data in Azure Data factory

Question

I have created a linked service to a Data verse Entity on azure data factory, I see few columns are missing when I previewed the data on ADF checked this columns were multi-select columns from the UI, is there any possible way to make it work, as I'm looking forward to populated those columns. I want these columns to appear on ADF so that I can push some data through it.

Answer 1

Hello Mohammed Faiz Qureshi,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you are having issue with missing multi-select columns of Data-verse entity, when previewed the data in Azure Data factory.

1. Check the projection tab to ensure your schema has been imported successfully. If you don't see any columns, select Schema options and verify the Infer drifted column types option. Check out the steps here: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-dynamics-dataverse and https://learn.microsoft.com/en-us/power-apps/maker/data-platform/export-to-data-lake-data-adf.
2. Manually add the missing columns in the mapping tab.

https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-dynamics-dataverse#explicit-mapping

Accept Answer

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.

Best Regards,

Sina Salam

Answer 2

@Mohammed Faiz Qureshi

Welcome to the Microsoft Q&A and thank you for posting your questions here

If your Dataverse table is the destination and you’re unable to see multi-choice columns, please do check the below steps

1. Publish Customizations: Sometimes, changes to Dataverse tables, especially those involving choice columns, require you to publish all customizations. You can do this from the Power Apps environment by navigating to Solutions and selecting Publish all customizations.
2. Check Permissions: Ensure that your account has the necessary permissions to view and modify the multi-choice columns. You might need to clear and re-verify your account permissions in the data source settings.
3. Data Source Settings: Verify that the data source settings in Azure Data Factory are correctly configured to include multi-choice columns. Sometimes, these columns might not be included by default, and you may need to manually add them.
4. Data Mapping: Ensure that the multi-choice columns are correctly mapped in your data flow. You might need to use a Derived Column transformation to handle the multi-choice data properly.
5. Refresh Metadata: Try refreshing the metadata in Azure Data Factory to ensure that all columns, including multi-choice ones, are recognized. This can sometimes resolve issues where columns are not appearing as expected.

If these steps don’t resolve the issue, please do let us know