Home → Questions →

ATOM feed

kristinnm

26 Dec, 2011 07:11 AM via web

Admin Functions

• Edit
• Remove

Is it possible to get query results as an Atom 1.0 feed so it can be imported into Microsoft PowerPivot?

1. Support Staff 2 Posted by Thorsteinn Yngvi Gudmundsson on 27 Dec, 2011 02:31 PM

   

   Hi Kristinn,
   At present we do not offer this service. We do, however, provide you with ways to download into Excel via a Live URL or alternatively, you can download .xls files, CSV & TSV. So gathering the data to use within PowerPivot in Excel should be easy enough (I assume the same goes for importing into the SharePoint version?

   You can start by signing up for a trial version of our PRO account, which provides 30 days worth of access to data. It also opens up the ability to export data from the website as oulined above.
   Hope this helps.

   Admin Functions

   • Edit
   • Remove

2. 3 Posted by kristinnm on 27 Dec, 2011 02:58 PM

   

   PowerPivot doesn't support import from file using an URL, only method is to use an ATOM feed.

   So i would need to download the extracts manually to disk and then refresh powerpivot everytime if i'm going to use the xls/csv/tsv format.

   This would be a really nice feature, this will enable me to create a live feed of Datamarket data into PowerPivot / Tabular models without doing any ETL work.

   Admin Functions

   • Edit
   • Split
   • Remove

3. Support Staff 4 Posted by Thorsteinn Yngvi Gudmundsson on 27 Dec, 2011 03:58 PM

   

   Right. OK - we will put the ATOM feed idea onto our product roadmap.
   Thanks for the suggestion.

   Admin Functions

   • Edit
   • Remove

4. Thorsteinn Yngvi Gudmundsson closed this discussion on 27 Dec, 2011 03:58 PM.

Comments are currently closed for this discussion. You can start a new one.