Forum Discussion
Solved
Power BI: Dynamic SQL parameters question
I am trying to do a Proof of Concept whether Power BI can be used to replace reporting in MicroStrategy/Narrowcaster. What I am currently stuck on is how to implement dynamic parameters that woul...
Hi OndrejVyhnal,
Power BI has notoriously limited support for dynamic parameters, and unfortunately, Oracle's connector does not support ? placeholders for parameter binding like SQL Server or PostgreSQL.
Use Value.NativeQuery, which does support parameterized queries in Oracle when done correctly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Thanks a lot for your advise...I tried to change the native query to include '?'
but got Oracle: ORA-00911: invalid character