Error - Update google sheets

[biajuda123]

Well, I have a spreadsheet on google sheets and configured in my report, The data is normally updated in the power bi desktop, but not in the power bi service (online).

I created a data stream to update the data, but it always returns an error where it says the page has timed out.

How to solve this problem?

This issue is directly impacting my organization!

[GilbertQ]

Hi @biajuda123 

Is the error when you are trying to update it in the Power BI Service or in Power BI desktop?

What happens if you change back your changes from the data stream, does it then work?

[biajuda123]

Hello

The error occurs when data is updated in the power bi service (online).

I created the data stream so as not to mess up my dataset, but even the stream is not updated either.

The error that returns to me is always the same:

"We timed out waiting for the page"
This is the current code:

  Source = Web.BrowserContents("https://docs.google.com/spreadsheets/d/e/2PACX-C8LL9uw2Nlg/pubhtml", [WaitFor = [Timeout = #duration(0, 0, 0, 5)]]),

(link changed).

[v-janeyg-msft]

Hi, @biajuda123 

Have you tried to set the timeout longer?

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[biajuda123 · Accepted solution]

I managed to solve the problem!

Google itself has a way to create an API that returns a JSON file to me.

So I created the API call and it worked perfectly.

A data stream that took 40 minutes to update is now taking about 54 seconds!

If anyone wants to understand the solution, search:

https://script.google.com/home