Passing parameter from Power Apps solution to a paginated report (Power BI Report Builder)

[npine]

I created a paginated report based on a Power Apps solution and published it in Power BI service. From the Power Apps canvas can I pass parameters like document ID to the paginated report? For example, the idea is from a canvas displaying Invoice ID 100, user will select a print icon, the Invoice ID 100 will be passed as a parameter to the paginated report and it will open the report with data from Invoice ID 100 that user can then print. I have been searching and from what I can see so far this is not possible. Is this still true?

Thank you.

[npine]

@Anonymous Thank you so much for all the help!

[npine]

Hi @Anonymous thank you so much for your response! I was able to follow your very clear explanations and screenshots. I created a Print Button. In the event "OnSelect" I used the Launch function and passed the URL of the paginated report with the parameters. It does load the paginated report but it was not passing the parameters. It opened to the paginated report still have to enter the parameters. I also followed the links that you sent on how to pass parameters since I have 4 parameters. When I reduced the parameter to just one so that I can use the exact syntax that you had it still was not working. It will load only the paginated report but not pass the parameter. What am I doing wrong? Do you have a sample syntax to pass multiple parameters? Again many thanks for your help!

[Anonymous · Accepted solution]

Hi, @npine 

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.

[Anonymous]

Hi, @npine 

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.