Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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 example table

Table
Cow
Chicken
Dog
Cat
Bird

 

Desired Single line list
'Cow','Chicken','Dog','Cat','Bird'

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

3 REPLIES 3
Anonymous
Not applicable

Hi again, I think I found the menu item to convert it

Anonymous
Not applicable

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. 

Ahmedx
Super User
Super User

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, "','") & "'"

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.