Forum Discussion
automatically refresh pbi - google sheet
Hi I'm new to PowerBI and I'd like some help to have my (now online) report updated automatically. It is built with a google sheet and an excel, I don't need the excel to be refreshed, only the g...
Hi Alexis. I'm not sure I got everything but let's see.
If you have a report connected to local data like excel (on premise gateway) and cloud data like google sheet (directly connected online) you must validate an option in your gateway to make it work. You can check that extra option to check in this blog post that specifies one of the three special configuration on the gateway online.
If the problem is regarding the specific conectiong to google sheet. I'm not sure which one is the best way. I have read in the past the Power Bi doesn't have a good Google Auth configuration. So you might be able to connect it this way:
https://blog.ladataweb.com.ar/post/189308808470/powerbi-conectar-desktop-a-un-archivo-en-google
Hope that helps,