Forum Discussion
Super UserWe cannot convert the value "[Table]" to type Table when refreshing via service
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.
Super UserAnonymous,
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.
tyw214Helper I
seems like I am getting this error too now using the August gateway version... :( really need help.