Forum Discussion

compscinj's avatar
compscinj
Frequent Visitor
8 years ago
Solved

Query Parameters Not Bound - Oracle Database

I have a report that is running a query against an Oracle Database. The query has a few filters that are often changed, so in other environments those are stored as variables. As I understand it from...
Data Modeling
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi compscinj,

     

    To reference a query parameter in query statement Where clause, we need to modify Power Query below: 

     

     

    Best Regards,
    Qiuyun Yu 

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi compscinj,

 

To reference a query parameter in query statement Where clause, we need to modify Power Query below: 

 

 

Best Regards,
Qiuyun Yu 

 

 

  • compscinj's avatar
    compscinj
    Frequent Visitor
    8 years ago

    Worked perfectly, thank you!