The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 my research, Power BI does not accept the use of the "DECLARE" statement for Oracle Databases.
After watching this video from Guy in a Cube, https://www.youtube.com/watch?v=iiNDq2VrZPY, I tried doing the same thing the video does at the beginning (Using a Power BI Query Parameter, can be found around 2 minutes) however I get the error that the variable is not bound. The only difference I can see between what I am doing and what Patrick is doing is that he is querying a MySQL database and I am querying an Oracle database. Does Power BI not support the same use of parameters for both?
Solved! Go to Solution.
Hi @compscinj,
To reference a query parameter in query statement Where clause, we need to modify Power Query below:
Best Regards,
Qiuyun Yu
Hi @compscinj,
To reference a query parameter in query statement Where clause, we need to modify Power Query below:
Best Regards,
Qiuyun Yu
Worked perfectly, thank you!
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
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.
Hi @compscinj,
In Power BI desktop, when you get data from Oracle database, do you call a stored procedure or get data from a table?
If it's stored procedure, would you please share us the query how you create that stored procedure on Oracle side?
Best Regards,
Qiuyun Yu
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
90 | |
83 | |
64 | |
58 |
User | Count |
---|---|
244 | |
128 | |
118 | |
79 | |
78 |