Forum Discussion
Passing parameter from Power Apps solution to a paginated report (Power BI Report Builder)
- Anonymous2 years ago
Hi, Anonymous
If you have multiple parameters, you'll need to pass all of your report-level parameters (mandatory) into your URL so that the paginated report can render your data based on those parameters. You can refer to the following two documents to learn how to pass multiple parameters in a URL:
Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn
In the following article, you'll learn more about using the Paginated Report URL parameter.
URL parameters in paginated reports in Power BI - Power BI | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
First, in Power Apps, you need to get the parameters that you want to pass to the paginated report. To illustrate this, I've created the following paginated report, where I have a ReportParameter1 parameter:
In order to be able to properly pass the parameters entered by the user into the paginated report in Power Apps, we need to use the URL for parameter passing. So, I got the link to the browser address bar when I open a paginated report in Power BI Service. This link will be used to dynamically receive the parameters that the user enters from Power Apps:
https://app.powerbi.com/groups/xxxxxx/rdlreports/xxxx?
Change the link to look like this:
https://app.powerbi.com/groups/xxxxxx/rdlreports/xxxx? rp:ReportParameter1=
At this point, let's create a canvas app in Power Apps:
Here I use an input box to get the paginated report that the user wants to refer to for the corresponding parameters:
I added a button, and then edited the button's events:
Launch("https://app.powerbi.com/groups/xxxxx/rdlreports/xxxx?rp:ReportParameter1=" & TextInput1.Text )
In this button, use the Launch function to load the paginated report with the passed parameters. This parameter comes from TextInput1.Text. When the user enters the corresponding parameter in the input box, clicking the button button will load the paginated report of the corresponding parameter:
You are described to select a print icon to pass the invoice ID to the paginated report. You need to be able to read this parameter from Power Apps and pass it to the Launch function. We have to implement this in a function that Power Apps can provide, as I did with TextInput1.Text to get the input.
If you don't know how to pass paginated report parameters, you can learn it by clicking the link below.
Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn
Create parameters for paginated reports in Power BI Report Builder - Power BI | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.