Forum Discussion
Do i need a gateway with these sources?
Hi joyce23,
The dataset uses Web connector to get data from Googlesheet doesn't require gateway when we do dataset refresh in Power BI service. The difference is whether we use the Web.Page in Power Query. If the Web.page function is using when getting data in Power Query, it requires gateway when we refresh such dataset in Power BI service.
Best Regards,
Qiuyun Yu
Community SupportHi joyce23,
As you are using web data sources, you need to use gateway if you want to refresh the dataset after you publish the report to Power BI service.
You can either install and configure on-premises data gateway or on-premises data gateway (personal mode). Then follow up this document to configure schedule refresh: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
Best Regards,
Qiuyun Yu
Hi, I am using google sheets for my database. i publish them to web as csv. does that need a gateway? I have a colleague using the same sources however she doesnt need a gateway like i do. she doesnt know also the difference. what do you think is the problem with my sources. thank you.
- v-qiuyu-msft
Hi joyce23,
The dataset uses Web connector to get data from Googlesheet doesn't require gateway when we do dataset refresh in Power BI service. The difference is whether we use the Web.Page in Power Query. If the Web.page function is using when getting data in Power Query, it requires gateway when we refresh such dataset in Power BI service.
Best Regards,
Qiuyun Yu
