Skip to main content
Finance forum
Suggested answer

ENUMS in PowerBI

editSubscribe (0) ShareShare
ReportReport
Posted on by 219
We expose our D365 F&O Data to Azure Data Lake, which is used as datasource for PowerBI-Reporting. As we know AX (F&O) has a datatype ENUM where the enumerations are stored as integer values in the database. In F&O application these ENUMs are implicitly displayed with a userfriendly label (user language depending). What is the best way to implement the ENUM-Label/-Labeltranslation in a PowerBI-Report, which is based on Azure Data Lake? 
 
BTW: I now there is a table SRSEnumValueTable (or something like this) inherited from earlier AX-Versions, where we had this inbuild OLAP-Cubes, but this table does not include all required Enums.
Attachments
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 756 on at
    ENUMS in PowerBI
    I've only ever been able to solve this with a custom export or table.
     
    Take a look at Microsoft.Dynamics.Ax.Xpp.MetadataSupport::EnumNames(), you can use it to iterate through all the Enum names and dump their metadata into a table for export to the DataLake, or just spit out a CSV depending on how often your enums actually change. 
     
    You can then use SysDictEnum to lookup Enum item Names and Values.
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    ENUMS in PowerBI
    Hi,
    If you want to implement something similar to FO in PowerBI, the ENUMs are implicitly displayed with a userfriendly label (user language depending), you might consider creating a mapping table: you can match the enumerated values to user-friendly tags, which allows for conversion between numeric values and tags.
    Best regards,
    Kevin

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans