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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
artpad
New Member

Error message on merging queries: We cannot convert a value of type Record to type List..

Hi! I'm trying to merge two queries, one a copied query from Kusto and the other a local csv. I want to merge on a common column containing a whole number and these are the steps I followed. 

Edit Queries -> Merge Queries -> Choose the two columns containing numbers and hit Okay -> Expand new column -> select only Column 2 (containing the string corresponding with the number in Query 2)

After this, the data looks great in the query editor, but when I hit Close and Apply, I get the error message: We cannot convert a value of type Record to type List.. 

 

Has anyone seen this error? I know that merging will put the whole record in the new column, but when I expand that record, shouldn't that just be showing that query's column 2 as a list?

1 REPLY 1
MarcelBeug
Community Champion
Community Champion

My suspicion is that this error must also be present somewhere in the query editor, at least I cannot think of any scenario in which this particular error would first show up when loading data.

 

Did you check all queries and all query steps?

 

Merging queries doesn't put records but tables in the new column. When this is expanded, then a code step is generated using function Table.ExpandTableColumn.

Your Column2 should be a table column (which is a list indeed, but not a separate list).

 

Maybe you can share your query code or some screen shots we can use for further investigation?

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors