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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Error when trying to c...
Power Apps
Unanswered

Error when trying to connect Google Sheets

(2) ShareShare
ReportReport
Posted on by BigDataPanda 8

"The tables didn't load correctly. 

Insufficient tokens for quota group and limit 'ReadGroupCLIENT_PROJECT-1d' of service 'sheets.googleapis.com', using the limit by ID '644771627308'.

Session ID: f921ea42-944f-3519-bc2e-d4757b1ed334"

 

I keep getting this error when I'm attemping to connect a Google Sheet as a datasource in Powerapp. Also I am currently working on the web broswer rather than my surface.

Categories:
Building Power Apps
I have the same question (0)
  • v-yamao-msft Profile Picture
    v-yamao-msft Microsoft Employee on at

    Hi BigDataPanda,

     

    Does this error message occur recently? Before this error message occurs, were you able to connect to Google Sheet as a data source?

     

    As a workaround, you could save your file on Google Drive, then connect to the file on Google Drive as a data source. Please also make sure the file is formatted as a table.

     

    Best regards,
    Mabel Mao

  • BigDataPanda Profile Picture
    BigDataPanda 8 on at

    Hello MabelMao,

     

    I'm assuming this is an issue with the Broswer version of the app. I've attempted again this morning and google sheets connects fine! Unfortunately when I was  attempting to connect anything to a table in a google drive, google sheets, and static sheets, I would get that error. 

    This make me ponder about the performances on building the Powerapp on the browser. My Co-Worker and I have been running into random issues throughout our progress in our app (which is still much faster than working on the app on our surface). 

  • Community member Profile Picture
    Community member on at

    Hi BigDataPanda,

     

    This is an issue with us running out of API calls quota from Google.  We are working with Google to increase the quota for us.  Unfortunately, this is not something that can be fixed directly on our side.  We will keep updates here.

     

    Thanks!
    Sameer

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi,

     

    Is there any update on the quota limit issue?

     

    I have been encountering the error very frequently when connecting to Google Sheets.

     

     

  • GalibRahman Profile Picture
    GalibRahman 5 on at

    I've been experiencing the same issue on both the Browser Version & Desktop Version, unfortunately. 

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I am also getting the same error, while working with google sheets. 

     

    In Ms flow, i am trying to read the google sheets, and it is throwing error, that it is unable to fetch the worksheet.

     

     

     

     

  • v-yamao-msft Profile Picture
    v-yamao-msft Microsoft Employee on at

    Hi @Anonymous, @GalibRahman,

     

    I try to create an app based on Google Sheet on both PowerApps studio for Web and PowerApps studio for Windows. But I get the error message looks like below:

    google sheet.PNG

     

    It seems that this issue has not been fixed yet. I will confirm from my side about this, and I will back once I got any updates.

     

    Best regards,
    Mabel Mao

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi all,

     

    After reinvestigation, I have found that in google sheet provide some per day limit to operation on google sheet.So after complition of limit its generate error.I am attaching a link to find all google sheet per day quota limit.

     

    please find below link of Quota Dashbord of google sheet :- 

     

    link: Quota Dashboard

     

    Thanks,

    satyam

  • Okerson_Matt Profile Picture
    Okerson_Matt 6 on at

    Has anyone heard of a solution to this? This thread is relatively old but the problem is still occuring for me. 

  • GalibRahman Profile Picture
    GalibRahman 5 on at
    I still haven't found one,unfortunately. I,too, continue to experience the same issue.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 519 Most Valuable Professional

#2
11manish Profile Picture

11manish 489

#3
Haque Profile Picture

Haque 327

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans