Unable to schedule refresh using google sheet as my data source as web connector

[Anonymous]

Dear all,

I prepared a dashboard with google sheet with web connector.

I checked my settings for scheduled refresh, it is greyed out. And my gateway is also greyed out.

Please help me do the live data properly.

TIA

[v-xicai · Accepted solution]

Hi @Anonymous ,

1.If your report dataset doesn't contain any on premise data source, that is to say the dataset only has the cloud data source Google sheet,  then it needn't to use the gateway and couldn't set schedule refresh.

You can manually refresh the dataset by using Refresh now,  Power BI automatically connects to the workbook on OneDrive, or SharePoint Online, about every hour to check for updates. If the workbook has changed, the data refresh synchronizes datasets and reports in Power BI Service with the underlying data in Google sheet.

2.If your dataset contains not only the cloud data source Google sheet but also some on premise data sources, then it needs to use the gateway,  add data source to gateway in Manage gateways page, and then you can configure schedule refresh. See more : On-premises data gateway , Add a data source ,  Configure scheduled refresh .

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[avatorl]

Do you have a gateway installed? Does it work with other datasets?
Do you have any other query in this dataset that uses on premises data and requires gateway?