Share via

When downloading a report what does data feed open with?

Manus, Jennifer 0 Reputation points
2025-09-23T17:50:16.7466667+00:00

I have a sql server and there is a report that I normally download into CSV. I noticed an option for data feed and was wondering what that opens with and what it does.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Karpurapu Durga Prasanna (Quadrant Resource LLC) 5 Reputation points Microsoft External Staff
    2025-10-14T07:39:30.77+00:00

    Hi @ Manus, Jennifer

    Welcome to Microsoft Q&A Forum.

    The Data Feed option in SQL Server Reporting Services (SSRS) allows you to export report data in a format called Atom Data Feed, which is essentially an XML-based structure designed for integration with other tools. Unlike a CSV file that you download manually, a data feed can be connected directly to applications like Microsoft Excel (PowerPivot) or Power BI, enabling dynamic data refresh and deeper analysis.

    For example, in Excel, you can go to the PowerPivot tab, click Manage, then Get External Data → From Data Feed, and simply paste the report’s data feed URL to pull in the data. Similarly, in Power BI, you can use the OData Feed connector under Get Data and enter the same URL.

    Since Atom feeds are built on the OData protocol, they can also be used with any other application that supports OData. This makes the Data Feed option a powerful alternative to static exports, especially when you need live, refreshable data for reporting or dashboards.

    Also, for your reference, I’ve downloaded a sample report from SSRS in both CSV and Data Feed formats. I have attached below. Please take a moment to review them they will help illustrate the differences in structure and how each format can be used depending on your needs.
    User's image

    Image 2

    Image 3

    I hope this information is helpful. If you have any further questions, please let us know. we can assist you further.

    Regards,
    Durga Prasanna K

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.