Gateway option stuck in Power BI web dataset preventing updates from multiple data sources

[Pujoni]

I created a dashboard with 4 connections. One reads documents from SharePoint (folder with .xlsx files that are later merged), two are Google Sheets connected via web, and one is a Google Form also via web. In the Power BI Desktop version, I can update normally and it retrieves everything without any errors. However, when I publish it, the web version doesn't update anymore. It keeps the Gateway option enabled (and it's not possible to disable it) in the dataset, and it doesn't allow accessing the credentials. This didn't happen before, I've made this same connection multiple times, so I don't know what could be happening!
I use free version!
= SharePoint.Files("https://contoso.sharepoint.com/sites/files", [ApiVersion = 15])
= Web.Page(Web.Contents("https://docs.google.com/spreadsheets/d/e/contosocodeforms/pubhtml"))
= Web.BrowserContents("https://docs.google.com/spreadsheets/d/e/contosocodesheet/pubhtml")
= Web.BrowserContents("https://docs.google.com/spreadsheets/d/e/contosocodesheet/pubhtml")

[ibarrau · Accepted solution]

Hi. The Web.Page function requires a gateway. So it will ask for it as long as you have that function. If you know about PowerQuery M, you can try getting the data without using the function. Of course it depends on how the data if it's possible.

If you can't get rind of the Web.Page. Then you must install a gateway somewhere and activate using cloud and onprem sources at the settings in order to just configure that single source and not all of them.
I hope that helps,