Refresh, but google sheet info doesn't update...

[Skosmek]

Hola PBI Community!

I am having an isse with PBI and Google sheet/form...

I made a Google Form and the response will transfer to google sheet. 

However... after submitting a response from Form and getting data to google sheet, it doesn't update after refresh...

Are there some settings that i have to modify??

If i can get any adive, that would be appreciated.

Thank you,

Shuhei

[v-chenwuz-msft]

Hi @Skosmek ,

Does power bi report any errors? What method did you use to connect to the Google sheet?
1 Connect Google Sheets to Excel. Connect Power BI and Excel
For this method make sure you have synced onedrive

2 Use the web connector to connect.

Please make sure you have published the sheet.

You can see how to do this in this article.

https://blog.coupler.io/google-sheets-to-power-bi/#FAQ_2_Will_the_dataset_be_refreshed_automatically 

Or this video.https://www.youtube.com/watch?v=2hFCeduIP6k 

Best Regards

Community Support Team _ chenwu zhu

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

[lbendlin]

Can you please let us know what the question has to do with Power BI ?