cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TiagoAsseituno Occasional Visitor
Occasional Visitor

SQL at Oracle DBA - Variable conditions

Hello all,
I have a report where I'm using an Oracle database to get info directly from my ERP.
And it is a simple SQL:
select * from database.table where item = 'TIAGO123' OR item = 'TIAGO432'
So far, so good. But where conditions can change, I can add more items or remove... So instead of having the end user editing the connection>source, I would like to know if there is a way to leave it flexible.
I have the items lists in one of the Excel spreadsheet where I connect to this SQL.
Let me know any doubts.
Thanks
Tiago
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: SQL at Oracle DBA - Variable conditions

@TiagoAsseituno,

 

You may take a good look at the following post.

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: SQL at Oracle DBA - Variable conditions

@TiagoAsseituno,

 

You may take a good look at the following post.

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.