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
Hi,
I have a table in power query that I want to convert into a SINGLE line list so I can use it as a parameter. I want to use the parameter in an "in" clause in a SQL statement.
Here is the example table
Table
Cow
Chicken
Dog
Cat
Bird
Desired Single line list
'Cow','Chicken','Dog','Cat','Bird'
Solved! Go to Solution.
pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiAM5vdvvIh8nFqPw?e=8tth7V
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiAIx2m_UnXzIz_Ls?e=HGWMj2
(x) => "'" & Text.Combine(x, "','") & "'"
Hi again, I think I found the menu item to convert it
Hi Ahmedx,
Thanks for the detailed instructions. I was able to follow them through. The only issue is that the result is a string, not a list. I am unable to create a parameter from the result. Do you know how to convert the string to a single-line list? All of the transformation options are grayed out for the result.
pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiAM5vdvvIh8nFqPw?e=8tth7V
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiAIx2m_UnXzIz_Ls?e=HGWMj2
(x) => "'" & Text.Combine(x, "','") & "'"
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 |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |