cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeHayden
New Member

Common Error - CONVERT TYPE RECORD TO TYPE LIST

Greetings,

 

I occasionally get the error "cannot convert type record to type list" upon trying to merge tables together or import blank queries in from Kusto.

 

I am not looking for specific solutions here - and I do not have specific examples at this time.

I am just trying to get background info on:

 

1) what is the difference between a 'record' and a 'list' in Power BI?

2) What is the operational issue(s) in converting between the two?

3) How can I avoid this error in the future?

1 REPLY 1
ChrisMendoza
Super User I
Super User I

@MikeHayden - It looks like @LarsSchreiber has created a nice looking blog that may help → https://ssbi-blog.de/lists-records-and-tables-in-power-query-how-when-and-why/






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

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

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.