Forum Discussion

noliverte's avatar
noliverte
Helper III
6 years ago
Solved

refresh data automatically google sheets

Hello,   I use powerbi desktop, and I use web connector to import all my google sheets data. I published my report on the web (app.powerbi.com).   How it's possible to refresh google sheets data...
Need Help
Show and Tell
  • edhans's avatar
    edhans
    6 years ago

    noliverte - You need a gateway, but as you correctly surmised, you cannot install it on your personal computer as you shut it off. You need to install it on a PC or server that is up 24/7. If you turn the PC with the gateway off, your report will not refresh until you turn that PC on.

     

    The On-Prem gateway is free. Just download, install, and configure. You'll then need to go to the Service under Settings, Manage Gateways and add that web source as a valid source the Gateway can use.

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    Tahreem24 - have you tried that? It was sometime in 2017 or 2018 that MIcrosoft moved Web based data sources to require a gateway. I think it was driven by security needs so people weren't mashing up internal data with web data and potentially sending confidential data to a website as part of a query. By forcing it to go through a gateway, a Power BI admin has to allow that websource.

    • Tahreem24's avatar
      Tahreem24
      Super User
      6 years ago

      edhans ,

      Yeah, I'd tried this. It was working seemlessly fine. But I haven't got a chance to work on since one year or so.

       

  • noliverte's avatar
    noliverte
    Helper III
    6 years ago

    Thank you for your response but I think I have to install gateway to refresh my data ? What do you think ?

     

    Noliverte