Forum Discussion

Advocate V

6 years ago

Cannot convert value [Table] to type Table

I have a query that is fine when refreshing on Desktop but when I publish to the service and try and refresh (both manually and by schedule) I get an error saying: We cannot convert the value ...

Community Support

6 years ago

Hi Veles ,

You may refer to the similar cases:

https://community.powerbi.com/t5/Service/We-cannot-convert-the-value-quot-Table-quot-to-type-Table/td-p/127838/page/2

https://community.powerbi.com/t5/Desktop/Cannot-convert-value-to-type-table/td-p/173959

https://community.powerbi.com/t5/Desktop/Cannot-convert-value-quot-0-quot-to-type-table/td-p/345637

https://social.technet.microsoft.com/Forums/en-US/30b551ad-be9f-4745-91d0-7a6fc7acdda0/expressionerror-we-cannot-convert-the-value-to-type-table?forum=powerquery

Best Regards,

Amy

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