Forum Discussion
[Expression.Error] We cannot convert a value of type List to type Record.
Hi there I am new to PowerBI and learning as I go. I am using PowerBI to query a REST API, and this is all working correctly. I have created a measure which again works correctly, however I have cre...
edhans
Community Champion
Community ChampionThat 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:
