Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Google Analytics Cannot be Added to Gateway

Good Morning,   One of our departments has built a dataset/report tied into Google Analytics. When configuring a scheduled refresh for them, I am running into the error below (Cannot be added to ga...
Need Help
heloise's avatar
heloise
Frequent Visitor
3 years ago

Hi everyone! 

 

I have the same issue; I'm using a gateway built by my IT so that I can have data refreshed everyday during the night automatically (otherwise I needed my computer to be on and connected to the company's network). 

Since I've added Google analytics as a data from PBI desktop, the data doesn't refresh anymore (it's working if I do it on desktop, but after publishing, I always get an error message anyway). 

 

The error message says: an error occured while treating the data of the dataset (I'm translating here from French).

{"error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Google Conversions (GA4).

 

When I check the data of the dataset on PBI Service, the only issue there is is "Google analytics > impossible to add to gateway":

 

And since Google analytics is the source for the Google Conversions (GA4) table, I assume it's connected?

 

I've checked the links that both collinq and Anonymous have posted, but it doesn't help; 

 

I found also this talk about it:

Solved: Re: [Need Help] Problems on adding Google analytic... - Microsoft Fabric Community

I've tried the steps given here: Merge or append on-premises and cloud data sources 

 

>But my gateway already allows "user's cloud data sources to refresh through this gateway cluster". 

When I try to add a new connexion source (in local I assume, as it says "You don't need to add the cloud data sources here.", Google analytics is not listed:

 

 

 

So I'm quite lost...

 

Thanks for your help!

 

 

 

heloise's avatar
heloise
Frequent Visitor
3 years ago

>Update on that; it seems the problem comes from one table only (although I set up several Google Analytics tables); from what I have tested, the problem occurs once I merge the Analytics table with data a table that is saved in my onedrive (and thus goes through the gateway). 

It's silly; the data from the 2nd table is also from GA, it's conversion data, but PBI doesn't allow me to load that data as I have an accent in the conversion name (and I haven't figured out how to change the conversion name all the while keeping the past data).

I guess it becomes a mixed table with two different sources; cloud and gateway and here comes the bug. 

 

I may try to see if:

1- I can pull out the 2nde table from the gateway (as it's only on onedrive)

2- or if it doesn't work, I put it on Google sheets