Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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 gateway). I have seen a couple other posts dealing with this error, but have not seen a solution that works, or that I understand 🙂 . Any assistance would be much appreciated.

Google Analytics Error.png

 

Thanks,

Matt

5 REPLIES 5
heloise
Frequent Visitor

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":

heloise_0-1692191549560.png

 

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 @v-stephen-msft 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:

heloise_1-1692191887385.png

 

heloise_2-1692192085729.png

 

 

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

v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,


Sorry to disturb you...


But did I answer your question ? Please mark my reply as solution. Thank you very much.

 

Best Regards,
Stephen Tao

v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

Gateway is not supported or required for Google Analytics.

 

Reference: Power BI data sources

 

And the refreshing can be done, you have to use the Google Analytics connector and then you can schedule the refresh in the Power BI Service.

Visualize and Explore your Google Analytics data with Power BI

 

Best Regards,

Stephen Tao

 

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

collinq
Super User
Super User

Hi @Anonymous ,

 

I have two thoughts about this.  First, does Google Analytics need a gateway?  It is cloud based and therefore shouldn't necessarily need a gateway.  Second, have you looked at the Gateway setup itself?  In the gateway you will get a more informative error message that gives you the problem.

 

Here is an (older but still relevant) link showing how to do it - with no gateway involved.

Power BI + Google Analytics = Power Analytics | Microsoft Power BI Blog | Microsoft Power BI

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors