The File Extensions Database

.ATOMSVC File Extension

  • Developer by: Microsoft
  • Category: Data Files
  • Format: XML

What is an .ATOMSVC file?

.ATOMSVC is Atom Service Document

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.

    Programs that open Atom Service Document
    Microsoft Power BI Desktop
    Microsoft Excel 2016

    How to solve problems with ATOMSVC files

    • Associate the ATOMSVC file extension with the correct application. On :
      Windows: Right click on any ATOMSVC file and then click "Open with" > "Choose another app". Now select another program and check the box "Always use this app to open *.ATOMSVC files". Mac: Right click (or Ctrl-click) the ATOMSVC file, then click "Open with" > "Other...". Then choose another program and check the "Always Open With" box. Linux: Right click on the file, and select "Open with" and choose another program. iPhone: Tap the file. If you do not see an app to open the file, then tap Share "Share" and choose an app. Alternatively, save the file. Then open the Files app Files app. There long-press on the file, then release your finger. You will see a black menu bar. Then tap "Share" and select an app. Android: Tap the Settings icon on your smartphone, then tap on the Apps section. There tap the Options icon in the top right-hand corner of the screen to change the default apps.
    • Update your software that should actually open .ATOMSVC is Atom Service Document. Because only the current version supports the latest ATOMSVC file format. Search, therefore, e.g. on the Microsoft manufacturer website after an available .ATOMSVC is Atom Service Document update.
    • To make sure that your ATOMSVC file is not corrupted or virus-infected, get the file again and scan it with antivirus software.