Forum Discussion
Power BI Paginated Report Multi-Lingual Prompt Issue - Please Assist
- 11 months ago
Hi Corinna_StAubin,
In Power BI Paginated Reports the parameter prompt field does not support expressions like ssrs, this is a current limitation. For multi lingual scenarios, the supported approach is to localize the parameter Available Values through a dataset query, so that the dropdown contents reflect the user’s language.
Or since you are embedding the reports in a custom web app, hide the built in parameter panel and provide your own localized parameter UI in the app, then pass the parameter values directly into the report at render time.Thanks and regards,
Anjan Kumar Chippa
Problem: Parameter prompts in Power BI Paginated Reports don’t auto-translate like the report body.
Fix: Use an expression in the parameter’s Prompt field:
=Lookup("employee_id", Fields!TranslationKey.Value, Fields!TranslatedText.Value, "UserDetails")
Or use User!Language logic to switch labels based on language.
⚠️ Heads-up: A known bug may cause prompts to revert to default names after selection. Microsoft is working on it.
Just a note here. I see you’re posting replies almost every minute. That kind of pace makes it seem like these are auto-generated rather than genuine contributions. If it’s only generic answers, people might as well go straight to GPT instead of coming here. The real value is when we share fixes we’ve tried or insights from our own work.
I’ll mark this one as inappropriate since it doesn’t feel in the spirit of the community.