Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Cannot convert the value to type list

Hi, I'm running into a problem again that seems to occur intermittently.    I've already posted about this issue here: https://community.powerbi.com/t5/Power-Query/Cannot-convert-to-type-List/m-p/...
Need Help
edhans's avatar
edhans
Community Champion
4 years ago

Try modifying this step:

Value = #"Converted to Table"{0}[Value]

to this

Value = #"Converted to Table"[Value]

The {0} was returing the first value of a list to scalar value, so you can no longer use it as a list in Table.FromList.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for this.

 

Looks like progress. A table is now returned, but now each cell is giving me the following Error. Thoughts on next steps?

 

Expression.Error: We cannot convert the value "https://host/$metada..." to type Record.
Details:
Value=https://host/$metadata#ACCOUNT_DETAILS

Type=[Type]