Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am getting the below error in the service when I try and do a refresh. I have stripped the query and can track it to a merge of data from a Web API to SQL. This happens before the data is expanded, and just the merge seems to cause this error, but only when refreshed on the service. This works without a problem in the desktop.
We cannot convert the value "[List]" to type Table.. The exception was raised by the IDataReader interface. Please review the error
message and provider documentation for further information and corrective action.
I had this issue. When i clicked 'refresh all' in power bi desktop, powerbi pretended everything was great and gave me no errors, despite the power bi service throwing this error. Only when i opened up power query editor and started clicking through each applied step on each datasource did i find a yellow hazard warning with the same error. In my case, here is what happened and how i fixedit:
Moral of the story for my case, If you try to perform a lookup to an excel file thats in sharepoint, it will transform all your [List]'s in your sharepoint list datasource into the string list! And then Power Bi desktop wont be kind enough to throw you an error when you refresh the data, but Power Bi service WILL throw an error and cause your refreshes to stop working.
I hope this helps someone!
Had exact same problem. Pinpoint the issue to append query from 2 sources. No issues if I separate them, but it will error out whenever I tried to merge them in power query. Was able to get around by using UNION to generate final table
Hi @dawidvh ,
Please try the following.
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 the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.