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.
Helper IHi 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 Learn
Best 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.
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
this got resolved with referring report parameters in actual report url but not embedded url of the report.