Skip to main content
cancel
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

Reply
BMG001
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.

 

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/transiti...

 

BMG001_0-1715890226324.png

 

1 ACCEPTED SOLUTION
v-zhouwen-msft
Community Support
Community Support

4 REPLIES 4
frankhillsnipe
Regular Visitor

We are experiancing issues with this as well. If your query includes an enum key value, then the $skiptoken in the odata.nextLink will contain the encoded _x0020_ value, but using that value in the query will cause the query to fail. If you manually replace the _x0020_ with a space or %20 the url in odata.nextLink will execute properly. 

BMG001
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 🙂

JohnnyFrostDP
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.

 

v-zhouwen-msft
Community Support
Community Support

Hi @BMG001 ,

You can submit your ideas here.

https://ideas.fabric.microsoft.com/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors