cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Powerwoman
Regular Visitor

Dynamics365BusinessCentral.ApiContentsWithOptions Content Language

Hi there,

I'm connecting Power BI to Business Central Cloud.
It would be great to receive content like the document type in a certain language, e.g. German.

Any ideas how to change/set the language in the connector?

Powerwoman_0-1674472075035.png

Thanks a lot!

6 REPLIES 6
RagnarE
Frequent Visitor

I wonder if this documentation might be of any help to you: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-connect-ap...

 

I suppose that to test this you would have to play around with Postman or a similar tool, and I'm not sure how this would translate into Power Query. I'd hate to use anything but the BC connector, but if forced... 

Powerwoman
Regular Visitor

Hi Ragnar,
thanks for your response.

 

First of all, there's no 'Add parameter' field in the Business Central Connector.

 

Powerwoman_3-1678435015420.png

So you need to use the ODATA-Connector,  but unfortunately it didn't work.

 

I created the parameter:

Powerwoman_2-1678434841954.png

 

Used it in the ODATA Connector:

Powerwoman_0-1678434797656.png

 

Result:

Powerwoman_1-1678434822101.png

But thanks for your idea! 😀

Hi again,

 

I haven't had a chance to test this properly myself, but maybe you can. How about if you start your query with this:
= Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null,

[

UseReadOnlyReplica=Replica,
Headers = [#"Accept-Language" = "en-US"]

]
)

I´ll admit that there's a good chance that the connector simply ignores this extra parameter, but it also doesn't spit out an error. I'd be very curious to know if it does change anything in BC instance in German 🙂

Let me just quickly add that "Replica" in the code above is simply a parameter which can be set to true or false. Replica could thus be replaced by a simple true.

Hi Ragnar,

thanks for your quick response 😀


I used your Connector and Code:

Source = Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [ UseReadOnlyReplica = true, Headers = [#"Accept-Language" = "de-DE"] ] ),

 

But it seems like PowerBI is just simply ignoring this new parameter:

Powerwoman_1-1678443221887.png


I had a quick check on the BC environment settings - but they are set to German local settings 

 

Powerwoman_0-1678443148935.png

But thanks again for you input!

RagnarE
Frequent Visitor

Hi.

 

I was sad to see that you haven't had a response as I'm grappling with the same thing. A colleague sent me this from ChatGPT but I haven't quite figured out how to actually do this:

RagnarE_0-1678185438036.png

 

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.