Refresh: works with desktop but fails on web "We cannot convert the value "[List]" to type Table"

[questionasker]

I have a power bi report that I keep having to manually refresh/publish the data from Desktop application since the scheduled refresh on the web fails with "We cannot convert the value "[List]" to type Table".

Issue has narrowed down the issue to a column I am expanding to new rows (Table.ExpandListColumn) which has both [List] type and null. Removing this line will allow the refresh to work.
-  #"Expanded Document.releaseIds" = Table.ExpandListColumn(#"Added Debt Column", "Document.releaseIds")

How could I fix this problem so that it'll auto-refresh on the web? 

[rchamplin]

I have a similar error (except mine cannot convert Table to List).  Works flawlessly on desktop, but the automated refresh fails.  I have a lot of queries (interfacing with a whole bunch of SharePoint tables) and I believe I have all the types matched up.  Did you end up finding the solution?

[arvindsingh802]

Please try the following.

• Tried setting perms to Organizational for all of them.
• Removing from the Power BI Service and republishing did nothing.
• If you have a list that has some information in nested Lists, expanding these Lists in the source query.

For more details, please refer to this post.
https://community.powerbi.com/t5/Service/We-cannot-convert-the-value-quot-Table-quot-to-type-Table/m...

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[questionasker]

Thanks for the reply. I have tried the first two bullets and they don't work. Second bullet only works if I remove the list expansion. As for third bullet, the data is just either null or list of strings. 

I had taken a look at the referred post before I posted and it didn't have solution that worked for me.