topic Re: RDL Embed URL with parameter not working in Developer

RDL Embed URL with parameter not working

scabral — Tue, 14 May 2024 13:12:52 GMT

I created an rdl report in power bi and published to a premium workspace that has an app built on top of it. When I open the app and open the rdl report and get the embed link for the report, i get this:

https://app.powerbi.com/rdlEmbed?reportId=d4cdca24-7c71-4e3a-99d5-9d053ff8f233&autoAuth=true&ctid=c5b7c693-4848-4451-bb02-ea923e6beb52&ctid=c5b7c693-4848-4451-bb02-ea923e6beb52&experience=power-bi

The rdl report has a parameter called paraAcctNo that accepts a 5 digit account number to filter the report. When i try to append the paramter to the end of the URL, the report opens but the parameter doesn't get loaded. Here is the URL that I am using:

https://app.powerbi.com/rdlEmbed?reportId=d4cdca24-7c71-4e3a-99d5-9d053ff8f233&autoAuth=true&ctid=c5b7c693-4848-4451-bb02-ea923e6beb52&ctid=c5b7c693-4848-4451-bb02-ea923e6beb52&experience=power-bi?rp:paraAcctNo=11027

Am i doing something wrong with how i append the parameter into the URL? I also noticed that the ctid is being passed twice in the embed URL. NOt sure why, but that is how it comes out of the embed link in the report. I tried to remove one of the ctid sections but still get the same issue with the parameter not passing in correctly.

thanks

Scott

Re: RDL Embed URL with parameter not working

Anonymous — Wed, 15 May 2024 06:03:11 GMT

Hi @scabral ,

Ensure that there are no spaces or special characters in the URL that could be encoded incorrectly

https://app.powerbi.com/rdlEmbed?reportId=d4cdca24-7c71-4e3a-99d5-9d053ff8f233&autoAuth=true&ctid=<your_ctid_here>&rp:paraAcctNo=12345

Regarding the fact that it appears twice, this may be a fault in the URL generation process. Removing duplicates should not affect the parameter passing functionality

You can check the following:

Ensure that the parameter in your RDL report is correctly set up to accept values and is not locked to a default value without the option to prompt the user.

Note the limitations regarding URL length and the number of characters used in parameters

See below for parameter limitations on paging reports:

Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

Embed a report in a secure portal or website - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: RDL Embed URL with parameter not working

scabral — Wed, 15 May 2024 10:53:05 GMT

thanks,

it worked! i think the issue was that I was using a ? instead of & before the parameter after the ctiid. I think the embed documentation said to use the ? but the & works.

thanks

scott