Google analytics will not refresh

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