Home : File Types : ATOMSVC File

.ATOMSVC File Extension

File TypeAtom Service Document

DeveloperMicrosoft
Popularity
2.3 (4 Votes)
CategoryData Files
FormatXML

XML

This file is saved in an XML format. You can view the XML structure and contents of the file in a text editor.

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.

More Information

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:

  1. Select the "Manage" button on the Power Pivot tab.
  2. Click "From Other Sources", then choose "Other Feeds".
  3. Browse to the location of the ATOMSVC file, and click Test Connection.
  4. Select the tables and views that you want to import data from, name them, and click Finish.
  5. Power Pivot will begin importing the data, which may take several minutes, then notify you if the import was successful.
  6. Click Close.

NOTE: Since ATOMSVC files are saved in XML format, they can also be opened by an XML editor or text editor.

FREE DOWNLOAD
Open over 300 file formats with File Viewer Plus.
Programs that open ATOMSVC files
Windows
Microsoft Power BI Desktop
Microsoft Excel 2016
with Power Pivot
Any text editor
Mac
Any text editor
Linux
Any text editor
Updated 4/20/2018

About ATOMSVC Files

Our goal is to help you understand what a file with a *.atomsvc suffix is and how to open it.

The Atom Service Document file type, file format description, and Mac, Windows, and Linux programs listed on this page have been individually researched and verified by the FileInfo team. We strive for 100% accuracy and only publish information about file formats that we have tested and validated.

If you would like to suggest any additions or updates to this page, please let us know.