Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

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":""}}],"exceptionCulprit":1}}} Table: Date_Dimension.
Cluster URI:
Activity ID: 8852e0bd-ca34-40bf-aeb8-e7b2e642855d
Request ID: 7ee670bc-2efe-49e7-b518-98ae2c450102
Time: 2021-06-11 11:24:26Z





It's ages since I looked at this. As far as I remember the problem was that, two years ago anyway, you could not have a Power BI report that used both on premise and cloud data.

Eventually, I decided to just walk around this problem. I built a C# program that extracted the previous days Google analytics information into an on premise database. Therefore the report was built using only on premise data.


Helper I
Helper I

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)
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?


Hi is this still an Issue? I finally figured it out

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

Super User
Super User

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:és-en-puerta-d...

I hope that helps,


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

Happy to help!

LaDataWeb Blog

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?


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.

They are different reports, using different database tables and Google analytics! Although, after fixing this one, I need to make changes to the report that is working (and hopefully not break it!). The changes, however, do not involve Google analytics.

We have looked at the privacy levels and believe they are okay.

I have a new report, for testing purposes. Added Google analytics, published it and it successfully refreshes. I have added one database table and it still refreshes-that's as far as I got yesterday. My first task today is to add a relationship between the database table and the Google analytics table. They question really is how far I go, as I really do not want to end up replicating the report (long story but we are trying to limit the amount of Power BI report, since it is not the best with my voice recognition software).

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors