Microsoft needs to provide a table or tables for storing all enums and their values whether created by Microsoft, ISVs, partners, or customers that is available to be exported to Fabric and Synapse.

The SRSAnalysisEnum table was used at one point; however, the menu optioins for this has been removed.

Microsoft has new system tables EnumIDTable and EnumValueTable which would appear to be what could be used; however, these tables can't be selected and aren't available to be extended.