web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Online (Business...
Power Automate
Unanswered

Excel Online (Business) Connector new API limits?

(0) ShareShare
ReportReport
Posted on by 19

Hey forum, 

I a struggling to solve the following issue and would appreciate any support on that topic from here:

We are running a PowerApp that triggers a flow every time the app is opened by a user. The flow connects to an excel File on SharePoint and retrieves the content of a table inside of the file. 

The file on SharePoint is only a couple of KB and contains a table with 5 columns and apprx. 900 rows. The flow fails when trying to retrieve the tables in the file.

We have been using this flow for months now without any issues. But starting from Thursday last week, wee have seen a steep incline in the number of errors. 

The error we are getting is this one: "The request is forbidden by Graph API. Error code is 'AccountQuotaExceeded'. Error message is 'Quota for this site has been exceeded. Changes to your data cannot be saved.'."
Indicating, that a Quota limit is reached. I don't quite understand why we are reaching a limit all the sudden, because neither the overall Flow usage nor the size of the file changed in the last months. 

The flow looks like this:

FelixR_0-1702891364207.png


The error message on te Get Tables Action is: 

{
  "status"403,
  "message""The request is forbidden by Graph API. Error code is 'AccountQuotaExceeded'. Error message is 'Quota for this site has been exceeded. Changes to your data cannot be saved.'.\r\nclientRequestId: <clientRequestID>\r\nserviceRequestId: <ServiceRequestID>",
  "error": {
    "message""The request is forbidden by Graph API. Error code is 'AccountQuotaExceeded'. Error message is 'Quota for this site has been exceeded. Changes to your data cannot be saved.'."
  },
  "source""excelonline-ne.azconn-ne-003.p.azurewebsites.net"
}


The flow is executed on the license of the user who started the app.

Update: While I am able to view the file on Sharepoint, I am getting the same message when trying to edit the file: 

FelixR_1-1702891886780.png

Any Idea where this could come from?


Please let me know if you need any more information to help me resolve the issue.

Thanks in advance. 

Categories:
I have the same question (0)
  • Verified answer
    FelixR Profile Picture
    19 on at

    Nevermind. Found the issue myself. 
    The Sharepoint that we were using was actually at the maximum storage capacity (something that I was not able to check myself). It seems that any incoming API calls are blocked when the storage limit is reached. 

    After cleaning up the Sharepoint of some unused files, the issue was resolved.

  • mheinst Profile Picture
    21 on at

    We had the same issue. AccountQuotaExceeded

     

    First I deleted all old files from the recycle bin in Sharepoint and increased the storage site limits and added a warning email for future storage issues.

    https://learn.microsoft.com/en-us/sharepoint/manage-site-collection-storage-limits

     

    Then we had to re-assign the fields in Update a row and Add a row into a Table. 

    Last thing was to trigger the fields that were wrong in the excel in Business Central with shipping it and unship it.

    That was our solution. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard