Forum Discussion

biajuda123's avatar
biajuda123
Regular Visitor
4 years ago
Solved

Error - Update google sheets

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 t...
Need Help
Show and Tell
  • biajuda123's avatar
    biajuda123
    4 years ago

    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

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

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's avatar
biajuda123
Regular Visitor
4 years ago

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