The Localization of parameter prompts of paginated report is already possible with issue

[ICD]

Since the last update of Power BI Report Builder (2024 April) is possible to localize parameter prompts of paginated reports!

See:
https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/set-locale-for-report-tex...

I configured my parameters prompts in this way.

Parameter name:                         BuildingId
Parameter prompt expression:   =IIF(User!Language.StartsWith("en"), "Building", "Gebäude")

When I publish the rdl file to Power BI service - everything is ok.

When I add to the report url: ?language=en-us
=> promprt = "Building"

When I add to the report url: ?language=de-de
=> promprt = "Gebäude"

but ...when I select somthing from the dropdown parameter the parameter's prompt changes to the name of the parameter BuildingId

What could be the reason?

[JourdanDixon]

It's a bug.  I put the formal business case into MS to create this feature since my place of work is one of their biggest users of the power platform and we need that translation option in a big way.  That was in December 2023 and they said it would take about this long to implement.  It was released without enough QA, obviously... as it works in PBI Desktop but not upon publishing.  Even if you just put =User!Language in as the expression for the name, the same thing will happen, making the expression unusable.  You're not doing anything wrong in your approach.  I've sent some detailed info to the project manager and dev, but am getting pushback.  The more people who complain about this, the better.  Put in a ticket for a fix and get as many others to do the same as you can.  I'll keep doing what I can from my end.

[ICD]

Hi, @JourdanDixon!

Thank you very much for your answer!

[v-nuoc-msft]

Hi @ICD 

Can you provide detailed sample rdl file and the results you expect. So that I can help you better. Please remove any sensitive data in advance.

Regards,

Nono Chen

[ICD]

Description of problem with localized parameters prompts in paginated reports

Just for testing - I created a simple sample rdl file - with 3 parameters, without body: 

rdl file

https://drive.google.com/file/d/14nkGB5IW8bFSB8uSS0l8Z6qLv7zSBebU/view?usp=drive_link

video

https://drive.google.com/file/d/1mRTurrBLGI-26yXlQtOiXANiagDMMquE/view?usp=drive_link

Parameter 1: BuildingId

Parameter 1 prompt expression: =IIF(User!Language.StartsWith("en"), "Building", "Gebäude")

Parameter 2: TypeId

Parameter 2 prompt expression: =IIF(User!Language.StartsWith("en"), "Type", "Art")

Parameter 3: FloorsCount

Parameter 3 prompt expression: =IIF(User!Language.StartsWith("en"), "Floors number" ,"Etagenanzahl")

When I change the language in the url (language=en-us / language=de-de), the parameters are initialized correctly, but when I select any value from the dropdowns (EXCEPT the last parameter), the parameter prompts are reset to parameter names

[AndreM]

Hello,

This has been fixed about a week ago. Please give it another go, and sorry for the inconvenience.

Best regards,

Andre

[ICD]

Hi,  @AndreM!

I've encountered another issue with localized parameter prompts in paginated reports. When publishing the report to Power BI Service and passing parameters via the URL, the values are set correctly, but the prompts display the parameter names instead of the localized labels. I used the same report from my previous post: https://community.fabric.microsoft.com/t5/Service/The-Localization-of-parameter-prompts-of-paginated...

The parameters are defined as follows:

Parameter 1: BuildingId
Prompt expression: =IIF(User!Language.StartsWith("en"), "Building", "Gebäude")

Parameter 2: TypeId
Prompt expression: =IIF(User!Language.StartsWith("en"), "Type", "Art")

Parameter 3: FloorsCount
Prompt expression: =IIF(User!Language.StartsWith("en"), "Floors number", "Etagenanzahl")

For example:

Using ?language=de-de&rp:TypeId=1 (the middle parameter) in the URL:

- The value for TypeId is set correctly.
- However, the prompt for TypeId shows "TypeId" instead of the German label "Art."
- Additionally, the prompt for the preceding parameter, BuildingId, also shows "BuildingId" instead of "Gebäude."
- The prompts for any parameters specified afterward, such as FloorsCount, are correctly updated to their localized labels.

This example illustrates that including a URL parameter updates the prompt for that parameter and any preceding ones, while prompts for parameters specified afterward are correctly displayed with their localized labels.

[AndreM]

Thank you for reporting this and the detailed description on how to reproduce this issue.

I created a Product bug to address this and will reply to this thread once a fix has been deployed.

Best regards,

Andre

[ICD]

Thanks for the quick response!

Best regards!

[ICD]

Thank you very much!!!

Best regards