Showing results for 
Search instead for 
Did you mean: 
New Member

CDS entities in ADLS Gen 2

I am using Export to data lake (Athena) feature in PowerApps to move data from CDS to ADLS Gen 2 which is creating a CDM folder.I am fetching the data in PowerBI desktop through PowerBI data flows created in the PowerBI service through model.json file.

However I am facing the issue that when option set fields are fetched, only the value for each option is retrieved and label is not. When I use the CDS connector in PowerBI desktop there is a seperate label column. Is there any recommended approach that i can use to get the option set labels when querying the data in ADLS Gen 2 through PowerBI desktop.


I have already tried Power BI Option Set Assistant in XrmToolBox. 

Super User III
Super User III

in the xrm toolbox there is a utility called the power bi option set assistant, which creates an entity with your option set labels and values specifically for this reason 

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Users online (11,443)