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 GA but get the below issue

issue

 

issue
Please could you help.
 
Thanks

 

Need Help

5 Replies

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

    Hi. If you have created a report with Google Analytics connector and published to service, then you don't need to add any kind of source. Many cloud source don't need that. You just need to open the schedule refresh settings and edit credentials under Data Source Credentials section. Login in there, and you are ready to go. 

    The sources you are adding in there are for using an onpremise data gateway that is not necessary for this connector.

    I hope that helps,

    • 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

         

  • CoderZen08's avatar
    CoderZen08
    Icon for Helper V rankHelper V
    2 years ago

    Hi rbist As a workaround, maybe you can try to test your connection with a 3rd party connector which pulls data directly from the GA API. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA connector in the data sources list:

     

     

    After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:

     

     

    There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.