Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is it possible to use list query Parameters in a SQL IN clause? Lets say my list contains Organisational Divisons from A to G where I for example choose C and F, can I somehow create a SQL Query like this:
SELECT * FROM mytable WHERE organisation IN (list_of_parameters)
The query would "unwrap" to:
SELECT * FROM mytable WHERE organisation IN ('C', 'F')
Note: My real data contains around 150 divisions and I want to be able to select everything between 1 and all divisons.
Thanks!
// Karl
@Anonymous,
Alternatively, you may try DirectQuery and use a Slicer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |