PowerBI RDL report

[StevenT]

Hi. My license is for powerbi pro.

I have a powerbi Report (.pbix) and a powerbi report (rdl). Both are in desktop form and published into my workspace

I also have a parameter that picks a record that the user clicks on from a matrix.
I'm trying to launch the report from a URL on my report, witht he parameter of the chosen record. SO it launches the powerbi report in powerbi.com and i can see the Parameter at the end of the URL String, but when it opens, the RDL defaults to the powerbi.com version which is a dropdown where the user chooses a value.

IS there a way to launch an RDL in powerbi.com that maintains the URL AND the pick? There's no errors when the URL contains the parameter, but it just keeps reverting back to the powerbi.com version.  I don't want it to open the RDL on my desktop because it defeats the purpose of running it from the workspace.

Any help is appreciated. Thanks!
Steven.

[v-sshirivolu]

Hi @StevenT ,
I would also take a moment to thank @Shahid12523  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @StevenT ,

Here’s a simple way to begin working with Paginated (RDL) reports:

Install Report Builder – Download Microsoft Report Builder at no cost from the official website. This tool is specifically designed for creating RDL reports.
Create a Report & Parameter – Develop your report within Report Builder and include a parameter, such as CustomerID. In the parameter settings, select “Allow external values” to enable input through a URL.
Publish to Power BI Service – Upload the .rdl file to either a Premium or PPU workspace in Power BI.
Use in Power BI – Access the report using a URL, for example:
https://app.powerbi.com/groups/{workspaceID}/rdlreports/{reportID}?rp:CustomerID=123

Alternatively, within a PBIX file, you can create a DAX measure to generate this URL dynamically and set it as a Web URL column for user access.

[v-sshirivolu]

Hi @StevenT ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

Hi @StevenT ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[Shahid12523]

Power BI RDL (Paginated) reports only accept parameters via URL if:

The parameter in Report Builder allows external values (not just a dropdown).

URL must use rp:ParameterName=Value.
Example:

https://app.powerbi.com/groups/{workspaceID}/rdlreports/{reportID}?rp:CustomerID=123

You need a Premium (or PPU) workspace → Pro alone won’t support this in Service.

[Chakua1951 · Accepted solution]

Hello, you could try with a DAX measure where you include the URL of the paginated report, the expression &rp:Alumno= (here replace it with the name of your parameter from the .rdl), and then use a SELECTEDVALUE to link the URL to the field. After that, apply the web URL configuration to the column in question. 

I hope this helps, regards.

[StevenT]

I've never used it before. Where do i get started with it?

[StevenT]

Is that a separate S/W package?

[MohamedFowzan1]

Hi @StevenT 

Parameters passed by URL will pre-fill the dropdowns but cannot bypass the parameter input UI. Opening the report in Power BI Desktop is not required and is not triggered by the URL.

If you want a smoother experience that automatically applies parameters without showing the parameter prompts, consider using Power BI Embedded:

• Power BI Embedded allows you to embed paginated reports in your own application.

• You can programmatically set parameters and control UI elements, hiding parameter inputs if desired.