Syntax required for referring paginated report embedded url parameters in direct query where clause

[Ashok_Gopeani]

Hi Team,

I am trying to build on paginated report with the data source  Oracle and trying to access through embedded rul like below

https://app.powerbi.com/xxxxx4b40-81a7-7dc0599e8645&experience=power-bi?rp:Cm_Run_ID=1695544

here Cm_Run_ID is parameter in paginated report. and i am trying to use this parameter as query param in my direct query as below SELECT * FROM table name WHERE cm_run_id = :Cm_Run_ID;

but this is not working for me, so could you please let me know who to refer url report parameters as query parameters.

thank you in advance.

[v-mdharahman]

Hi @Ashok_Gopeani,

Thanks for reaching out to the Microsoft fabric community forum.

From what I can see, the parameter setup in your report and dataset looks correct. You’re using ":Cm_Run_ID" in your Oracle query, the parameter type is set to Integer, and it’s properly mapped in the dataset properties.

The main issue appears to be with the URL format you're using to pass the parameter. In your current URL "https://app.powerbi.com/xxxxx4b40-81a7-7dc0599e8645&experience=power-bi?rp:Cm_Run_ID=1695544", there are two question marks (?), which can cause the query string to be misinterpreted and prevent the parameter from being passed correctly.

Just make sure there's only one '?' to begin the query string, and use '&' to add additional parameters.

I would also take a moment to thank @Akash_Varuna, 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.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[Ashok_Gopeani]

Hi @v-mdharahman : i think i have used only one question mark(?) in the url and i have verified one more time, still i am getting same issue.

[v-mdharahman]

Hi @Ashok_Gopeani,

If the URL is correctly using only one '?', and you're still seeing that the parameter isn't getting passed to the query, a few additional things might be worth checking:

* Ensure the report parameter is named exactly Cm_Run_ID (case-sensitive) and matches what's used in     the URL (rp:Cm_Run_ID=1695544).

* ALso try to open the report without any parameter first to ensure it's not caching an older state or

   running with defaults.

* Try changing the parameter’s data type from Integer to Text just to see if the value comes through.

   Sometimes, even if types appear to match, implicit conversion issues can block the value.

Even after all the mentioned steps you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with Microsoft Support.

Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Best Regards,
Hammad.
Community Support Team.

[v-mdharahman]

Hi @Ashok_Gopeani,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

[v-mdharahman]

Hi @Ashok_Gopeani,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[Ashok_Gopeani · Accepted solution]

this got resolved with referring report parameters in actual report url but not embedded url of the report.

[v-mdharahman]

Hi @Ashok_Gopeani,

I am glad that your issue has been resolved. Can you please mark the helpful reply as solution or provide your workaround and mark it as solution so that other community members can find the solution easily.

Best Regards,

Hammad.

[Ashok_Gopeani]

@Akash_Varuna :

i think i am associating URL parameters with query parameters correctly..

https://app.powerbi.com/xxxxx4b40-81a7-7dc0599e8645&experience=power-bi?rp:Cm_Run_ID=1695544

SELECT * FROM table name WHERE cm_run_id = :Cm_Run_ID;

Parameter setting on dataset

please verify above informaiton and let me know where i done the mistake...

one thing i have observed here is whatever url param value i have set that is not passing to query parameter in the direct query... 

please let me know if i need to do it differently

thank you

[Akash_Varuna]

@Ashok_Gopeani Ensure the URL parameters are correctly formatted (e.g., ?rp:Cm_Run_ID=1695544) and that the report parameter matches the Oracle column data type (e.g., Integer). Link the report parameter to the query parameter correctly, and test the functionality.