Forum Discussion
Convert power query table to a single line list
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 examp...
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