Forum Discussion
Refresh Google Sheets in Power BI
Anonymous,
You can use Function.InvokeAfter() function to set wait time between calls in Power Query.
Alternatively, you can use R script to refresh Google sheets and set Sys.sleep(30) as described in the following similar thread.
https://community.powerbi.com/t5/Desktop/HTTP-429-Error-while-refreshing-data-from-Google-Sheets-using-R/td-p/264416
Regards,
Lydia
Hello All,
I am authenticating and dowloading Google sheets in my Power BI Desktop. I am using Function.InvokeLater(..20 sec..) between two sheetIDs download in the same Google Sheet. But right now Each time I download new Google (Individual) sheetID I generate a new Access Token. Should I save Access Tokens in a DB and use the same Token for sheets downloaded within 1 hour of the Access Token generation?? And after the Token expires and I am trying to access Google Sheet, I would regenerate new Token.
I this case will I get (429) error while accessing consecutive Google Sheets, I will still have to use: Function.InvokeLater(..20 sec..)
Is there an alternative way.
Thanks for your help.
Hello All,
I am trying to figure out, how many read calls it takes to read/refresh Google Spreadsheet (70 tabs) in Power BI (1 tab at a time). My quota limit in Google Sheet API is 100 requests in 100 sec per user. Should I try to upgrade my quota limit in Google Sheet API??? or read multiple Tabs in Multiple Read Call??
Thanks for your answer,
Vithi Mittal.