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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 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