Forum Discussion
Helper ISyntax required for referring paginated report embedded url parameters in direct query where clause
this got resolved with referring report parameters in actual report url but not embedded url of the report.
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 Anonymous : 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.
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 LearnBest Regards,
Hammad.
Community Support Team.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.