Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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?

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors