locked
Data feed identifier for Reporting Services RRS feed

  • Question

  • I want to query data from a report in SSRS 2019 Standard in Excel by using data feed.

    As described in Generate Data Feeds from a Report (Report Builder and SSRS), I exported the data feed service document:


    But when I open the service document xxx.atomsvc, there is no such an URL with the format described in the documentation of Microsoft:
    https://<server name>/ReportServer?%2f<ReportName>rs%3aCommand=Render&rs%3aFormat=ATOM&rc%3aDataFeed=<Identifier>


    Instead, the URL looks like

    http://<servername>/ReportServer?%2F<Report>&amp;rs%3ACommand=Render&amp;rs%3AFormat=ATOM&amp;rc%3AItemPath=<tablename>"

    How do I get the <Identifier> to use the URL format provided for Microsoft, where can I find or configure it?

    Appreciate any answers!

    Thanks, Andreas

    P.S. Sorry for the obviously wrong choice for the forum, but I was not able to make a choice in the list of available forums which makes any sense. There is no SSRS forum, either no SQL Server forum.

    Wednesday, November 25, 2020 9:08 AM

All replies

  • Hi Andreas 0815,
    For questions about Sql server, I suggest you ask the question on the Microsoft Q&A forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang


    "Visual c#" forum will be migrating to a new home on Microsoft Q&A ! We invite you to post new questions in the "Developing Universal Windows apps" forum’s new home on Microsoft Q&A ! For more information, please refer to the sticky post.

    Thursday, November 26, 2020 1:27 AM