Generate Data Feeds from a Report (Report Builder and SSRS)

You can generate Atom-compliant data feeds from paginated reports, and then use the data feeds in applications such as Power Pivot or Power BI that can consume data feeds.

The Reporting Services Atom rendering extension generates an Atom service document that lists the data feeds available from a report. The document lists at least one data feed for each data region in the report. Depending on the type of data region and the data that the data region displays, Reporting Services might generate multiple data feeds from a data region.

Atom service document contains a unique identifier for each the data feed and you use the identifier in a URL to view the content of the data feed.

For more information, see Generating Data Feeds from Reports (Report Builder and SSRS).

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

Generate an Atom service document

  1. On the Reporting Services web portal, navigate to the report for which you want to generate data feeds.

  2. Select the report so the report is run.

  3. On the toolbar, select the Export button and choose the Data Feed option.

    A message appears asking you if you want to save or open the atomsvc document that contains the data feed.

  4. Select Save to save the document to the file system, or select Open to view the document content before saving. By default, the document opens in a browser.

  5. Browse to the location to save the document.

  6. Optionally, change the name of the document.

    Note

    By default, the document name is the report name.

  7. Verify the document type is ATOMSVC File, and then select Save.

  8. Optionally, open the .atomsvc file in a browser or text or XML editor.

View an Atom-compliant data feed

  1. If the Atom service document is not already open, locate it and open it in a browser such as Microsoft Edge.

  2. Copy the URL of the data feed that you want to view from the Atom service document to the browser.

    The format of the URL is the following:

    https://<server name>/ReportServer?/<ReportName>&rs:Command=Render&rs:Format=ATOM&rc:ItemPath=Tablix1

  3. Press ENTER.

    A message appears asking you if you want to save or open the atom document that contains the data feed.

  4. Select Save to save the document to the file system, or select Open to view the data feed before saving.

  5. Browse to the location to save the document.

  6. Optionally, change the name of the document.

    Note

    By default the document name is the report name. If the Atom service document has multiple feeds, by default all use the same name, the report name. To differentiate them, rename them to use meaningful names.

  7. Verify the document type is ATOM File, and then select Save.

  8. Optionally, open the .atom file in a browser or text editor or XML editor.

Next steps

Export Reports

More questions? Try asking the Reporting Services forum