Forum Discussion

OndrejVyhnal's avatar
OndrejVyhnal
New Member
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

kushanNa's avatar
kushanNa
Super User
1 year ago

Hi OndrejVyhnal 

 

if you know your parameter values then this can be done ,

 

you need to create a parameter table and use it as a slicer and bind that parameter table column to your parameter ,

 

in this video he explain how to do it , in here he is using date as a parameter you can use your month IDs in here instead

 

https://www.youtube.com/watch?v=pXU_SpiBWUA&t=18s&ab_channel=DataPlatformCentral 

 

but if you do not know the parameter and if it can be any text then it will get complex and you will need to use something like power apps i believe