cannot setup automatic refresh

[hanswittoeck]

Failed to update data source credentials: The culture 'en-BE' can't be converted to an SAP Language Code. Try the 'LanguageCode' option instead.

This error pops up. I have no idea where the LanguageCode option can be found

[Tad17 · Accepted solution]

Hey @hanswittoeck 

Check out this thread and let me know if it answers your question: https://community.powerbi.com/t5/Power-Query/SAP-BW-On-Prem-Gateway-language-issue/td-p/51827

If not we may need a screen shot of the full error code/message.

Also try this from the Microsoft article on the subject:

"You can also specify two additional Advanced options: Language code, and a custom MDX statement to run against the specified server.

If you don't specify an MDX statement, the connection setting displays the list of cubes available in the server. You can drill down and select items from the available cubes, including dimensions and measures. Power BI exposes queries and cubes exposed by the Open Analysis Interfaces."

https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector (Search the word "Language" as it only appears once)

If this helps please kudo.

If this solves your problem please accept it as a solution.

[Tad17 · Accepted solution]

Hey @hanswittoeck 

Check out this thread and let me know if it answers your question: https://community.powerbi.com/t5/Power-Query/SAP-BW-On-Prem-Gateway-language-issue/td-p/51827

If not we may need a screen shot of the full error code/message.

Also try this from the Microsoft article on the subject:

"You can also specify two additional Advanced options: Language code, and a custom MDX statement to run against the specified server.

If you don't specify an MDX statement, the connection setting displays the list of cubes available in the server. You can drill down and select items from the available cubes, including dimensions and measures. Power BI exposes queries and cubes exposed by the Open Analysis Interfaces."

https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector (Search the word "Language" as it only appears once)

If this helps please kudo.

If this solves your problem please accept it as a solution.

[hanswittoeck · Accepted solution]

Hi

This issue is with Microsoft now. It seems it is momemtarily not possible to set up automatic refresh with a personal gateway if your datasource is a SAP BW connector