web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

(0) ShareShare
ReportReport
Posted on by 30

Hi all,

I have been using the following guide

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/export-to-data-lake

To go into Power Apps and  export to data lake.

It all worked really well but for one thing.

Our table contains lots of choice columns. These choices have a code and a descriptor

The only thing we get out in the csvs are the codes.

And there is no way to get out the choices into a look up that we can use 

Is there anything we can do to get things sorted? Or is there anywhere I can raise a ticket to have this issue looked at

The Code is basically useless to us without the choice descriptors

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi Debbie,

    You can go https://admin.powerplatform.microsoft.com/support to raise a ticket.

    Regards,

    Leah Ju

  • Debbie Edwards Profile Picture
    30 on at

    thanks I will do that

  • Mr.QuestiongMark Profile Picture
    15 on at

    There is a table SRSAnalysisEnums in DAX. If you export it you might have all your enums (choice)

    Thanks,

  • Debbie Edwards Profile Picture
    30 on at

    When you say DAX, to me that means Power BI Data Analysis Expressions so I dont really understand the solution here? When I go into Tables in the back end (Power Apps) I dont have a table of that name

  • Debbie Edwards Profile Picture
    30 on at

    When you say DAX, to me that means Power BI Data Analysis Expressions so I dont really understand the solution here? When I go into Tables in the back end (Power Apps) I dont have a table of that name

  • Debbie Edwards Profile Picture
    30 on at

    I have raised a ticked but its taking a long time for the Dynamics team to understand the issue. I should say that the choices codes are also exporting when you use the API in Data Factory and again, there is no way to get the descriptors

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 51

#2
Martin Dráb Profile Picture

Martin Dráb 39 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 26 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans