Atom Service Document
3.3 | 11 Votes
What is an ATOMSVC file?
An ATOMSVC file is an Atom service document generated by SQL Server Reporting Services (SSRS), which is used to create, publish, and manage reports about SQL Server data. It contains connection information about one or more data feeds used to populate regions in a report with data from SQL Server. ATOMSVC files are saved in XML format.
ATOMSVC files are used for integrating data feeds from SQL Server into compatible applications, such as Microsoft Power BI and Microsoft Excel with the Power Pivot add-in. The data feed integration allows users to access current data without the need to manually enter the data.
The data is fed from SQL Server to a report in order to populate the different regions of the report, such as tables, lists, charts, graphs, matrices, and gauges. Each region of a report has its own data feed, but some regions may have multiple data feeds depending on their structure. These data feeds are stored in the ATOMSVC file.
It is important to note that the ATOMSVC files do not store the actual data seen in each region. They store information for connecting to one or more data feeds, which may be the URL address of the web server or the address of a local or shared folder on a computer that points to the location of the data.
To create an ATOMSVC file, select the "Export to Data Feed" icon next to a report in the "Reporting Services" web portal and save the document.
To open the ATOMSVC file in Power Pivot in Excel:
- Select the "Manage" button on the Power Pivot tab.
- Click "From Other Sources", then choose "Other Feeds".
- Browse to the location of the ATOMSVC file, and click Test Connection.
- Select the tables and views that you want to import data from, name them, and click Finish.
- Power Pivot will begin importing the data, which may take several minutes, then notify you if the import was successful.
- Click Close.
NOTE: Since ATOMSVC files are saved in XML format, they can also be opened by an XML editor or text editor.