Forum Discussion

Dragon496's avatar
Dragon496
Helper II
5 years ago

Google analytics will not refresh

I have a report that uses both databases, through a gateway and Google analytics. The report works fine in Power BI desktop but any attempts to refresh the dataset, on service, fails. I have another report, which uses Google analytics as well and that still works.

Please find the details of the error below:-

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"GoogleAnalytics failed to get the response: 'The underlying connection was closed: An unexpected error occurred on a send.'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"GoogleAnalytics"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"GoogleAnalytics"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://www.googleapis.com:443/analytics/v3/management/accounts?start-index=1&quotaUser=xxxxxxxxxxxxxxxxxxxxxx"}}],"exceptionCulprit":1}}} Table: Date_Dimension.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 8852e0bd-ca34-40bf-aeb8-e7b2e642855d
Request ID: 7ee670bc-2efe-49e7-b518-98ae2c450102
Time: 2021-06-11 11:24:26Z

 

Thanks

Need Help

8 Replies

  • Dragon496's avatar
    Dragon496
    Helper II
    5 years ago

    I now know what the problem is, I just do not know how to fix it!

    As already stated, my report uses on premises databases, through a gateway and Google analytics.

    I have a couple of 1 row, one column tables-MinDate and MaxDate. An example of 1 of the formulas I use is:-
    = if Date.From( List.Max(#"rent_account_validation"[Date Time])) >= List.Max(#"All Web Site Data"[Date]) then
    Date.AddYears(Date.EndOfYear(Date.From( List.Max(#"rent_account_validation"[Date Time]))),1)
    else
    Date.AddYears(Date.EndOfYear(List.Max(#"All Web Site Data"[Date])),1)


    I then use these values to restrict the date ranges in my slicers.

    I have established that it is these 2 tables/formulas that are preventing Google analytics refreshing. Obviously, the issue is this formula is referring to on premise databases AND online sources. Could anyone explain why this is a problem and how to solve this?

    Thanks

      • Wheels497's avatar
        Wheels497
        New Member
        2 years ago

        Please look at my reply from July this year-I have not had to look at this for a couple years.

  • ibarrau's avatar
    ibarrau
    Super User
    5 years ago

    Hi. When you are working with cloud and onpremise data you need to specify your gateway that there is data that can be cloud with a check box in its configuration. Once you do that you can configure the credentials for cloud and only add sources for gateway. Go to gateway settings and activate:

    The configure its credentials like the report with only analytics. That should be enough for it to refresh. You usually don't have to add a source in the gateway for cloud data.

    You can read about this additional gateway settings here: https://blog.ladataweb.com.ar/post/647097339965734912/powerbigateway-opciones-de-interés-en-puerta-de

    I hope that helps,

     

    • Dragon496's avatar
      Dragon496
      Helper II
      5 years ago

      Unfortunately, that option is already checked.

      I should have added, to my original question, the following:-
      the report in question, initially existed under a different name, and as far as I can remember, the data, including Google analytics, was refreshing. A few weeks ago, I created another copy of the report, in order to adhere to our naming standards. It was only yesterday, I realised I had never set up the scheduled refresh, for this copy of the report.

      Also, I have a different report, using a different workspace, that successfully refreshes its data, including Google analytics.

      Any further suggestions?

      Thanks

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        5 years ago

        Hi Dragon496 

        do you mean you have a reportA uses both databases, through a gateway and Google analytics, and the report refreshes OK.
        then you create a copy of reportB, and its refresh on service through gateway fails while refresh in desktop works OK, right?
        Besides, you have a different report using different datasource & workspace, successfully refreshes its data?

         

        Best Regards,

        Community Support Team _ Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.