Jun 3

Report not running

2 comments

I am getting an error running a report that is querying an internet accessible OData wcf :

 

An error has occurred during report processing. (rsProcessingAborted)Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)Failed to execute web request for the specified URL. (rsXmlDataProviderError)For more information about this error navigate to the report server on the local server machine, or enable remote errors

Jun 4Edited: Jun 6

Hi Brian,

SSRS does not directly support OData feeds (with OAuth). We have put together some sync apps for sourcing data from SharePoint lists and Project Online (ListSync and ProjectSync) if these are the sources your after.

We're planning to release a new data collector app for sourcing data from any Rest or OData feed secured via OAuth.

We also have an internet accessible sample sql database (see the help menu and getting started guide) if you just want a data source to play with.

 

Could you add a screenshot of your data source configuration and I'll see if I can help get you progressing? Or email me at support@thorapps.com if you'd prefer to keep it private.

 

Adrian

 

Thanks for your email Brian. I have amended my comments above to clarify SSRS support for OData Versus OAuth.