Error with online refresh

[BPrinsloo4035]

Hi, I'm trying to schedule an online refresh but it is failing with this error:

we cannot convert the value "[record]" to type list

I currently have to do a refresh in Power BI desktop and then publish to the web when I want to update the data.

Any idea how I can identify where the problem is?

[v-mengzhu-msft]

Hi @BPrinsloo4035,

Did you do a refresh before this error occurred? Was it successful?

According to the error message, it was caused by a change in the type of the "record" value, can you tell me what you did about it? At the same time, can you tell me what type of value "record" is?

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@BPrinsloo4035 , refer if some old solutions can help

https://community.powerbi.com/t5/Service/We-cannot-convert-the-value-quot-Record-quot-to-type-Record...

https://stackoverflow.com/questions/63614882/power-query-expression-error-a-value-of-type-record-can...

[BPrinsloo4035]

Thanks so much for sharing these. I already had a look at both and unfortunately neither addresses my issue. My error cannot convert record to LIST whereas the other cannot convert record to record or text