Please Help: Suddenly I cannot update my data from the data origin (Google Sheets). JSON ERROR

I HAVE AN UPDATE: I SOLVED THIS (it wasnt easy tho. Had to try different stuff)

So, basically, here is the thing: I had some sheets that I imported as "WEB PAGE" (google sheets) and others as "Microsoft Excel xlsx.", also from the same spreadsheet of Google Sheets. What I think happened is that Power Bi no longer runs extenses data bases using the "WEB PAGE" way. I had to go to Power Query and change the way it was imported using "WEB PAGE" and changing it to "Microsoft Excel xlsx". This was a lil confusing because I had several "steps" in the data and had to go to "advanced query" and start changing the code language.

This was it. Thank you