Forum Discussion

rbist's avatar
rbist
Frequent Visitor
2 years ago

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 ...
Need Help
rbist's avatar
rbist
Frequent Visitor
2 years ago

Thanks for your reply.

So I am also connected to a sql database which uses the on premise gateway and can refresh.

 

I have just created a test and only connected to google analytics and the refresh worked.

Is it not possible to schedule a refresh for both SQL and GA data of the same dashboard? As my dashboard combines both.

 

Thanks

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
2 years ago

Ok. 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

 

  • rbist's avatar
    rbist
    Frequent Visitor
    2 years ago

    Okay thanks, I appreciate it, I will give it a go and let you know