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
Hi Vinay, thanks a lot for your feedback.
Could you please share a bit more details regarding this 'Value.NativeQuery' approach?
Hi OndrejVyhnal,
Please check the similar thread which has been addressed in the community
Regards,
Vinay