Forum Discussion
Super UserWe cannot convert the value "[Table]" to type Table when refreshing via service
Hi everyone,
I'm really wishing there is a solution to this refresh problem.
I am trying to append a sharepoint list to an Excel workbook. Both reside in sharepoint. There's no error when refreshing using Desktop but getting this in the service We cannot convert the value "[Table]" to type Table.
In an attempt to find the root cause, I have removed some steps in my query, disabled loading some of them etc then publishing the dataset and doing the refresh in the service. The refresh via service works fine until I did the append. It seems the mashup logic in the service can't handle this kind of combination (that error by the way is very vague).
I've already tried using the steps within the same query to do an append instead of appending different queries and making sure that the permission for all data sources is organizational but these attempts didn't work.
4 Replies
danextian There were/are still some challenges in the mashup from my understanding. Are you on the latest gateway? I know some of them have been resolved.
- danextian
Anonymous,
I forgot to mention that both data sources are in Sharepoint Online for Office 365.
- danextian
And so I ended up importing the contents of the Excel file to a separate Sharepoint Online List the combine the two lists instead of Excel and a Sharepoint list. This setup did not return an error when the data source was refreshed from the service.
This shouldn't be a solution though but just a workaround. I'm hoping MS would fix this soon. It is unfortunate that a mashup that works in Desktop returns in an error in the service not to mention that the error really is vague.
