Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Good evening, I have a problem:
I have thi sql statement
select * from table1 where field1 in (parameter)
The parameter can has two or more value, for example parameter = ('A','B','C')
In the sql oracle I don't have any problem but:
"I must use direct query for import the data, how I can introduce multiple value in parameter?"
I usually use this statement
1 - I create a parameter in power bi desktop
2 - I take the sql statement and use '" ¶meter& "' in the parameter
In particular:
select * from table1 where field1 in ('" &nameParameterPowerBi&"')
You can help me?
Thank you
Best regards
Solved! Go to Solution.
I found a solution.
It is enough to remove the ' in the query sql when I write the sql statement.
So my sql statement with parameter become:
select * from table1 where field in (" ¶menter& ")
and in the parameter in power bi I add 'value','value', so it will become in the direct query when it run
select * from table1 where field in ( 'value','value')
Best regard
@Anonymous , Are you looking for this option
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
I found a solution.
It is enough to remove the ' in the query sql when I write the sql statement.
So my sql statement with parameter become:
select * from table1 where field in (" ¶menter& ")
and in the parameter in power bi I add 'value','value', so it will become in the direct query when it run
select * from table1 where field in ( 'value','value')
Best regard
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |