Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello ,
I am trying to pass the parameter in Oracle SQL in pagianted report using Oracle Database conneciton. But i am getting missing expression error or syntax errors. where ABC = @ParameterName
the expression is working with ODBC conneciton (preview).
Could you please help me with the correct paramterter expression with Oracle database.
Thank you,
Paramjit
Solved! Go to Solution.
Hi @Paramjit ,
Please use ":" instead of "@" like so:
where ABC = :ParameterName.
SQL Server uses an @ sign for the parameters, but Oracle uses a : (colon) to prefix it’s parameters.
Reference: defining oracle query parameters - Report Designer (SSRS) (microsoft.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Paramjit ,
Please use ":" instead of "@" like so:
where ABC = :ParameterName.
SQL Server uses an @ sign for the parameters, but Oracle uses a : (colon) to prefix it’s parameters.
Reference: defining oracle query parameters - Report Designer (SSRS) (microsoft.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there a way to pass multiple parameters? So I want to do a direct query to the Oracle database through Paginated reports but I want the user to be able to query on Order Number OR Customer name or both. I got it to run but it returns no results because if I enter an Order number but not a customer name, it sends null to the customer name and then returns no results for the query because the customer name is populated for that order number I tried to lookup. Thanks.
Hi @moldepc
Did you ever get queries to work with the option of having user input multiple parameters for ex. Customer and Country, where either might be left blank ?
Hi Everyone,
Any help on this pls.
Thank you.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
26 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |