CODEWITHSUNDEEP
powerquerydynamics-business-central
BE50
BE50

Reputation: 31

Business Central: API settings to return localized column names in Power Query

I use Power Query to get content from Business Central. I fail to get localized (Danish) column names. Here are my findings:

In web ui: Danish column names, Danish content
Web UI

When exporting to Excel: Danish column names, Danish content Export to Excel

When loading into Power Query without headers: No Danish. PQ with noheaders

When loading into Power Query with Headers=[#"Accept-Language"="da-DK"]: System column names, Danish content.
PQ with header

I have tried adding other headers with no success. How can it be done? I can add a renaming step i PQ but this would not be very productive...

Upvotes: 0

Views: 92

Answers (1)

Gerardo Renteria Garcia
Gerardo Renteria Garcia

Reputation: 1

i hope this can help you and give you some hints: https://learn.microsoft.com/en-us/power-bi/guidance/multiple-language-locale BR GR

Upvotes: 0

Related Questions