Bjarki Már Gunnarsson on 17 May 2024 10:25:54
BC24 has forced ENUM fields in BC to return as strongly typed text, replacing spaces with x0020x, etc. The only workaround is to configure the API to return results in a specific language, which forces ENUMs to be translated. However, this is not feasible when using the Dynamics 365 Business Central Connector in Power BI, which requires replacing values in all tables with ENUM fields. While this workaround functions, it places extra load on Power Query (PQ).
Microsoft needs to provide an additional parameter for language in the connector to resolve this issue, similar to the replica parameter.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/transition-to-api-v2.0
Original issue:
https://community.fabric.microsoft.com/t5/Desktop/Dynamics-365-Business-Central-BC24-forced-API-v2-0-on-ENUM/m-p/3926661#M1259154