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...
  • 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