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 

     

     

compscinj's avatar
compscinj
Frequent Visitor
8 years ago

I am not calling a stored procedure (though I am working on something like that for another dashboard), but instead using parameters declared in Power BI directly inside my query. 

 

An example would be if I have a parameter I declared in Power BI called Sales_Threshold, and gave it a value of 50,000. I then have a query that pulls data with a WHERE clause that says Sales > 50,000. Instead of writing 50,000, I would prefer to write Sales_Threshold so if it never needs to be changed I can just change the parameter in Power BI instead of changing every instance of the number in the query.