Forum Discussion
[Expression.Error] We cannot convert a value of type List to type Record.
Community ChampionThat error is coming from Power Query when you are loading data, and somewhere either in your M code or source data, you are getting a list of data and are then trying to handle it like a record, thus the error.
Go into Power Query and look at the query that should now have a yellow triangle next to it and see if you can find the source of the error. We'd need screenshots to really help. If you find a "cell" that has the word "Error" in it, please click on the white area next to the word Error (not on the word Error itself) and give us a usable screenshot of what is appearing in the small window at the bottom of the query in yellow.
Hi thanks for the reply, I check the query editor no steps have a yellow triangle against them. I am selecting the column
Then selecting the drop down
I click on 'Load more' then I recieve the error
Hope that helps
- edhans
That is because in your data, beyond the first few hundred rows it initially looks at, there is a List embedded where it expects a Record. When you click Load More, it reads the entire data set until:
- it gets 1,000 values for the filter, at which point it stops
- It reads all of the records and populates the filter with what it found, not to exceed 1,000 records.
Yours stops when it encounters an error. It may not even be in that field. It just cannot process more.
On this table, tell it to Keep Errors.
The do a Refresh All so it reads everything. It should show you the record(s) that have the issue.
OK done now it returns a value of 758 on that column as has having errors, if I click the first entry I get the following:
Jimmy801Hello Anonymous
is this column a calculated column? Probably there the error is coming from
BR
Jimmy