Open .atomsvc files with Power BI

Anonymous 

"If you do not have an application on your computer that can open a report feed, save the document for future use on a computer that has Power Pivot in Excel. The document that you save specifies an address to the report. It does not contain data from the report.

1. Open a report from Report Manager, SharePoint, or a report server.

2. On the report toolbar, click the Export as Data Feed button: 

3. Click Save to store the .atomsvc file on your computer. The file specifies the report server and location of the report file.

To use the .atomsvc file later, you can open it in Power Pivot in Excel to import the report feed. For more information about how to specify a data service document for report feeds, see Import report data using a URL to a data service document in this topic.

You can also publish this file to a data feed library on SharePoint to make it available to anyone who wants to use report feeds in other workbooks or reports. For more information about data feed libraries, see Power Pivot Data Feeds on MSDN."

Reference:
Import Data from a Reporting Services Report - Excel (microsoft.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.