Here’s my problem. I am pulling data from RoseReport summaries using the data feed button on each page. I connect to 8 different data feeds this way and combine the imported data into a master PowerPivot table. Refreshing the PowerPivot connections works fine. At first. The problem is that a day later, refreshing the PowerPivot data (ie, clicking Refresh All in the PowerPivot window) generates the following error for every data feed (except one): Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: The remote server returned an error: (500) Internal Server Error.. An error occurred while processing the 'LegacyLink' table. The operation has been cancelled. Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used. Also, checking the Table properties for these failing tables yields the error, "Cannot load table "Policheck". Make sure the data source is available, and that Source Table Name and Schema Name are valid. Details: Unable to obtain schema for data feed 'table1'. Please make sure this feed exists." The reports are updated overnight, so something tells me that the updating process is causing the error (the one report that does not cause data feed problems is a little used report which I suspect is no longer active; the data has not changed in several days). This morning, for instance, everything was still working, then 2 hours later failing. Checking the reports, it appears they were updated in the interim. Needless to say data feeds are useless if they fail when the underlying data is updated. There must be a solution, but I have no ideas.

Hi, Did the datasource/dataset name contain spaces? If so, the name will be illegal from SSRS 2008 and be replaced with "_", which might cause the issue. Please check it in your case. thanks, Jerry