Forum Discussion
scheduled refresh for google anayltics data
Hi, I am trying to set my power BI to automatically refresh each morning. On the dekstop version I have created a dashboard with GA data. I have published and tried creating a connector with ...
ibarrau
Super User
Super UserOk. Let's see. You have a datasource with a SQL Server onpremise and Google Analytics Cloud. Alright, if you want to work with both sources (cloud and onpremise) then you can do it. You need to install a Gateway as Standard Mode in order to help SQL Server to get refreshed. Once it's installed. The account used for logged in should open Power Bi Service -> Manage Gateways -> open the gateway settings and turn on the following check:
That setting allow you to use a gateway for the onpremise and avoid it for cloud. You can add the SQL Source as you were doing and just edit credential for google analytics like the test you did.
I hope that make sense
Okay thanks, I appreciate it, I will give it a go and let you know