Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Dynamics 365 Business Central BC24 forced API v2.0 on ENUM fields

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.




Community Support
Community Support

Frequent Visitor

@johk  yep, when using a real API connection, the when useing the connector you cant do it.. + no parameters+ field selection etc... but we get convience, @v-zhouwen-msft  thanks for the link will do 🙂

New Member

hi @BMG001 read the bottom part about the enums:
Transitioning from API v1.0 to API v2.0 - Business Central | Microsoft Learn

It seems there are ways to get factables for the enums through the metadata and entityDefinitions. But hey, i agree it is a weird change.


Community Support
Community Support

Hi @BMG001 ,

You can submit your ideas here.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors