Cannot connect to Excel Services REST API

Question

Hi there,

I am currently trying to connect an audit report to the Excel Services REST API, for the purpose of eventually connecting that file to Power BI to visualize my data analytics.

I am using the following format to try and access this API:

http://<ServerName>/_vti_bin/ExcelRest.aspx/<DocumentLibrary>/<FileName>/<ResourceLocation>

However, when I attempt to connect to the API, I am thrown an error message that the item does not exist despite it clearly being there in my document library. Below is an image of the screen that I see:

I would appreciate any support and advice you could provide!

Sincerely,

Jericho

Answer 1

Hi Jericho,

According to the following article, the Excel Services REST API applies to on-premise SharePoint, and since you are using SharePoint Online, you may use Microsoft Graph API instead:

Excel Services REST API

"Note:

The Excel Services REST API applies to SharePoint and SharePoint 2016 on-premises. For Office 365 Education, Business, and Enterprise accounts, use the Excel REST APIs that are part of the Microsoft Graph endpoint."

You may also refer to Lee-MSFT's reply in the following thread to check the details of using Microsoft Graph API from SharePoint Online to access your Excel files:

How to access Excel Data stored in Sharepoint Online Document Library using Excel Rest API in a Sharepoint Framework (SPFx) app?

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​​

Please let us know if you have any further concerns.

Best Regards,

Nathan

Answer 2

Hi Jericho,

May I know if my information above could address your concern about the Excel Services REST API? Please let us know if you have any further concerns.

Best Regards,

Nathan