Hi @YU,
A few questions:
1. Are you getting literal values (constants or enum values) in your reports?
2. Are you using Synapse link for fabric to pull data from D365 FO into PowerBI?
Suggestions:
There are two tables in D365 Finance that are available at the application database but this is accessible only in lower environments.
We had a similar requirement with a customer where we wrote a simple X++ script to populate all enum names from Microsoft.Dynamics.Ax.Xpp.MetadataSupport::EnumNames() into a csv file and then use the table as a part of the Synapse Link for Fabric table and push the literal values into a PowerBI report.
Alternatively, to validate the enum values/literals during an upgrade, we used a SQL query to validate the literal or constant values (in case of upgrade).
1. EnumIDTable (Contains enum definition and value).
2. EnumValueTable (Contains individual enum values like enumID and enumValue as integer, Name as the symbol/label).
---------------------------------------------------------------------
select a.NAME, b.ENUMID, b.ENUMVALUE, b.NAME AS EnumName
from ENUMIDTABLE a
INNER JOIN ENUMVALUETABLE b
on a.ID = b.ENUMID
where a.NAME = '<EnumName>'
order by b.ENUMVALUE;
---------------------------------------------------------------------
Hope this helps. Happy to answer questions, if any.
