We cannot convert the value "[Table]" to type Table when refreshing via service

[danextian]

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.

[Seth_C_Bauer]

@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]

@Seth_C_Bauer,

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. 

[tyw214]

seems like I am getting this error too now using the August gateway version... 😞 really need help.