Forum Discussion

KFP's avatar
KFP
Helper I
8 years ago
Solved

Google Sheet connection won't update

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! 

Need Help
  • KFP's avatar
    KFP
    8 years ago

    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! 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      KFP
      Helper I
      8 years ago

      Anonymous, 

       

      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. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        KFP,

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

        Regards,
        Lydia