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,

 

Based on my test, I also get error when reference query parameter in Where clause. I have sent a email to consult this issue internally, will update here once I get any information. 

 

Best Regards,
Qiuyun Yu