Skip to main content
Microsoft Idea

Power BI

Completed

Create English Step Names Option in localized Power BI Query Editor

Vote (50) Share
's profile image

on 06 Feb 2016 17:14:41

Localized Power BI Desktop creates local step names in query editor. There should be an option to choose: Create English Step Names to avoid confusion when Power BI is used in international environments.

M language is English, DAX is English and step names should be English too.

Administrator on 02 Jul 2016 00:13:06

I'm glad to report that this option is now available in the June Update of Power BI Desktop: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-update/ Option to generate Step Names in English Query Steps generated within the Query Editor dialog are by default localized to the “current installation language”. For instance, adding a Remove Columns step via the Query Editor would result in a new “RemovedColumns” step if using the English-US version of Power BI Desktop. A common area of feedback from many users is that this approach does not scale well when they share Power BI Desktop files with other users running different localized versions of the product and these users also make changes to their queries, as it results in a mix of languages in the Step names. In this update, we’re introducing a new option to “Always generate Step names in English”. Users can now control whether the Query Editor should automatically generate Step names in the current installation language (old behavior, and still the default behavior going forward), or lock it down so that step names are generated in English. This setting applies to all files created in the current machine. This option is available under “File -> Options -> Global” and it only shows up in non-English versions of Power BI Desktop (as it means no change in behavior for English versions).

Comments (7)
's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:25:04

RE: Create English Step Names Option in localized Power BI Query Editor

Thanks ******!!

's profile image Profile Picture

Marco Russo on 05 Jul 2020 22:25:02

RE: Create English Step Names Option in localized Power BI Query Editor

Kudos for that!!

's profile image Profile Picture

Jussi Roine on 05 Jul 2020 22:17:58

RE: Create English Step Names Option in localized Power BI Query Editor

Great idea!

's profile image Profile Picture

Jussi Järveläinen on 05 Jul 2020 22:17:34

RE: Create English Step Names Option in localized Power BI Query Editor

Great idea! Localizing script languges anywat doesn't sound liike A good idea, although seen that VBA etc...

's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:16:40

RE: Create English Step Names Option in localized Power BI Query Editor

Agreed!

's profile image Profile Picture

Tiedon hakija on 05 Jul 2020 22:16:37

RE: Create English Step Names Option in localized Power BI Query Editor

Totally agreeing, it's frustrating for beginner user to use and modify given scripts because you never know which step names / parts of code needs to be in finnish.

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:15:38

RE: Create English Step Names Option in localized Power BI Query Editor

It would be nice to see this option also in Power Query with English as a default.