Forum Discussion
Power BI Paginated Report Multi-Lingual Prompt Issue - Please Assist
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
Community SupportHi Corinna_StAubin,
Thank you for reaching out to Microsoft Fabric Community.
The report body can use Lookup() or dataset Fields, so your placeholder expression with Lookup works. Parameter prompt expressions cannot use dataset fields or Lookup(). That is why your Lookup approach that works in the body fails for the parameter area and the prompts stay in English.
Since the reports are embedded in a custom web application and the app already controls the language selection, the recommended approach is to hide the SSRS parameter pane and render localized parameter prompts directly in your application UI.
Then pass parameter values(including language) into the report and when calling the report pass values using rp:ParameterName=value in the URL or by the embed API.
This avoids SSRS limitations, keeps translations consistent and works across all your reports.
Thanks and regards,
Anjan Kumar Chippa
This works for SSRS but not for Power BI Paginated Reports as options are not available in Paginated reports as are in Power BI Paginated Reports. Please correct if we are wrong and provide more details. When we apply the syntax an error is thrown.