Google Sheet connection won't update

[KFP]

The tables in the "Edit Queries" scene are up to date. However, the same tables are outdated in Desktop -> Data. Refreshing the data shows no error but new rows won't come in. 

Does anyone know why and how to fix? Thanks! 

[v-yuezhe-msft]

@KFP,

I am unable to reproduce your issue in February update of Power BI Desktop(2.55.5010.581). Do you use web entry in Power BI Desktop to connect to the file resided in Google Sheet? And do you use the February update of Power BI Desktop? 

Also please click Refresh button as shown in the screenshot below and check the result.




Regards,
Lydia

[KFP]

@v-yuezhe-msft, 

Thanks for replying.

I am using version 2.55.5010.521, updated this week. Yes, I connect with a web url. I refreshed using that button. The data from SQL database refreshed, not the Google Sheet data. 

[v-yuezhe-msft]

@KFP,

I am not able to reproduce this issue, could you please share me the source file? 

Regards,
Lydia

[KFP · Accepted solution]

Sorry this is silly. I just checked again and found out that I disabled the refresh for that table previously. I don't usually do this therefore didn't think of checking it. It works fine now. Thanks!