Alternatives to pulling data from ATOM Data Feed?

Question

I did some extensive searching and was unable to find the answer to my question: Are there alternatives to pulling data using ATOM Data Feeds other than Microsoft Powerpivot? I am trying to set up a connection to MS Access so I can populate some tables using data that currently has to be accessed through an SSRS embedded on a Sharepoint dashboard. I do not have access to the server, so I can't create my own connection at this time. Powerpivot has been the only method that returns data outside of manually going to the Sharepoint. I want the data to automatically populate in MS Access 2010.

Answer 1

Access 2010 can’t natively turn an SSRS Atom (OData/ATOM) data feed into a linked table the way PowerPivot can. But you still have workable options.

What you can do:

1. Call the SSRS Atom feed from Access VBA, parse the XML, and append rows into a table.
2. Use an intermediate file (CSV/Excel) refreshed by a scheduled script (PowerShell/.NET), then import/append in Access.
3. If allowed: upgrade to Access 2013+ which adds an “OData Database” connector.
4. Power BI / Excel Power Query + scheduled refresh → Access imports the refreshed file. (No server access needed.)