language
6 TopicsDefault values for field parameter with language support?
I've got a field parameter to which I've added language support using the method describere here: Synchronize multiple field parameters - Power BI | Microsoft Learn _p_location_resolution = { //english ("region", NAMEOF('dim terminal'[region]), 0, 1), ("country", NAMEOF('dim terminal'[country]), 1, 1), ("city", NAMEOF('dim terminal'[city]), 2, 1), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 1), //swedish ("region", NAMEOF('dim terminal'[region]), 0, 2), ("land", NAMEOF('dim terminal'[country]), 1, 2), ("stad", NAMEOF('dim terminal'[city]), 2, 2), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 2), //spanish ("región", NAMEOF('dim terminal'[region]), 0, 3), ("país", NAMEOF('dim terminal'[country]), 1, 3), ("ciudad", NAMEOF('dim terminal'[city]), 2, 3), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 3) } A problem with this is that if I add a language to my model but forget to update all field parameters there is no fallback. I use this field parameter in a slicer and If I filter for a language that is not supported by the field parameter the slicer becomes empty. My question is if it is possible to modify this in order to add a default definition? I tried letting ChatGPT be creative and it came up with this: _p_location_resolution = VAR SelectedLanguage = SELECTEDVALUE('languages'[ISO abbreviation], "en") RETURN SWITCH( SelectedLanguage, "en", { ("region", NAMEOF('dim terminal'[region]), 0, 1), ("country", NAMEOF('dim terminal'[country]), 1, 1), ("city", NAMEOF('dim terminal'[city]), 2, 1), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 1) }, "sv", { ("region", NAMEOF('dim terminal'[region]), 0, 2), ("land", NAMEOF('dim terminal'[country]), 1, 2), ("stad", NAMEOF('dim terminal'[city]), 2, 2), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 2) }, "se", { ("región", NAMEOF('dim terminal'[region]), 0, 3), ("país", NAMEOF('dim terminal'[country]), 1, 3), ("ciudad", NAMEOF('dim terminal'[city]), 2, 3), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 3) }, // default to english { ("region", NAMEOF('dim terminal'[region]), 0, 1), ("country", NAMEOF('dim terminal'[country]), 1, 1), ("city", NAMEOF('dim terminal'[city]), 2, 1), ("terminal", NAMEOF('dim terminal'[terminal]), 3, 1) } ) But this gives the error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value". Unfortunately I'm too new to Power BI and DAX to determine if it's just a tiny fixable error or if I'm not allowed to write DAX code like this in a field parameter. I'm guessing that the field parameter definition is not reloaded when changing the language filter so it isn't possible to do something like this but hey, I got to ask.652Views0likes1CommentChange Report Server language
Hi guys! I would like to change the language of the Report Server from English. For example the language of buttons (like favourites, settings, etc..). I know that I can change the language of the visualization with browser settings, but it's not happening with buttons. Is this possible somehow? Thank you in advance for your answer!6.7KViews0likes2CommentsLanguage Switch after upload to PBI Report Server
Dear Community, after the report is uploaded to PBI report server, the language for some of the labels is switched from English to German. Is it possible to set English as a default language without change of the browser settings? Many thanks in advance for the answer!621Views1like1CommentPower Bi Report Server does not load language file from Visual Studio initially
Hi PBI experts, besides PBI Desktop, we use Microsoft Visual Studio for designing and altering Tabular Models. There you can easily export a language file, then edit it with a text editor and then import the language file. In Power BI Desktop the language of the user's system is selected automatically. Last month, we have installed the PBI report server. We still have a issue with the language file loading in a internet browser. When opening the report via an internet browser, the language file from Visual Studio is not loaded initially. Only, after refreshing the browser (F5) the language file will be selected an the report is translated (similar like in PBI Desktop). Even after logging out and again logging in, the language file will be loaded. Do you have an idea why this happens and how I can fix it? Best regards Ömer S.736Views0likes1CommentPBIRS: Error when Danish letters (Æ, Ø, Å) in Foldername or Reportname
Hi, I have an issue when using the Danish letters in Foldernames or Reportnames on PBIRS. If the Report- or Folder-name contains (Æ, Ø or Å) I get an error when: -Manage -Replace --> "Could not replace item. You are not allowed to replace the selected item. Contact your administrator to obtain the necessary permissions." And for Excel-reports the "Download" buttom in Excel-Online (via OOS) download the file with weird name and no extention when folder- or report-name contains (Æ, Ø or Å) ...It works fine when (Æ, Ø or Å) isn't in the name. PBIRS version = (Jan 2019) 1.4.6960.38798 Regards TaicoSolved2.9KViews0likes1Comment