Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Solved! Go to 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,
Happy to help!
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,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.