Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Export table data to A...
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 Debbie Edwards 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

  • Debbie Edwards Profile Picture
    Debbie Edwards 30 on at
    RE: Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

    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

  • Debbie Edwards Profile Picture
    Debbie Edwards 30 on at
    RE: Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

    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
    Debbie Edwards 30 on at
    RE: Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

    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

  • Mr.QuestiongMark Profile Picture
    Mr.QuestiongMark 15 on at
    RE: Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

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

    Thanks,

  • Debbie Edwards Profile Picture
    Debbie Edwards 30 on at
    RE: Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

    thanks I will do that

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export table data to Azure Data Lake Storage Gen2 (Choices coming through as codes not descriptors)

    Hi Debbie,

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

    Regards,

    Leah Ju

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,885 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans