Forum Discussion
[Need Help] Problems on adding Google analytics to data gateway
Sorry, I figured it out myself, no need to include Google Analytics in the data gateway. I spent two hours on it and installed on-premises gateway personal mode... Turns out it was a waste of time.
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 link that you snet v-kkf-msft : 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!
>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