CODEWITHSUNDEEP
datasetssrs-2008odatapowerpivot
Brent Pabst
Brent Pabst

Reputation: 1176

Get OData or Atom Service feed for SSRS 2008 R2 Shared Dataset

Is there anyway to get a shared dataset to simply dump it's contents in an Atom or OData feed that can then be consumed somewhere else? In our scenario we want to build just the datasets and let users consume them from PowerPivot or elsewhere.

Thanks, Brent

Upvotes: 1

Views: 5663

Answers (2)

Eric Wood
Eric Wood

Reputation: 11

It does not look like SSRS can easily consume OData sources but that they are considering it.

http://connect.microsoft.com/SQLServer/feedback/details/559570/ssrs-should-be-able-to-use-odata-as-a-data-source

In the following article Mattias suggests a workaround that might meet your needs by using the XML data source and embedding your OData query in the URL

http://mskold.blogspot.com/2011/05/tfs-odata-services-as-data-source.html

Upvotes: 0

akshayl
akshayl

Reputation: 617

You might find this useful:

http://technet.microsoft.com/en-us/library/ee240754.aspx

Upvotes: 1

Related Questions