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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MrsPickles
Regular Visitor

Google analytics 2.0 connector fails for one property only

Hi,

 

Seems like this might be an issue with a specific GA4 property but I am stuck on how to troubleshoot. I have three GA4 properties that I create simple dashboards for (screenPageviews, sessions and pageTitle, date). For one of the properties the qeury just hangs on "evaluating" and never proceeds beyond this. The other two proceed as normal.

 

For the property that doesn't work, in the query editor the data comes through in preview with no problem at all.

If I remove the pageTitle (leaving screenPageviews, sessions and date measures) the query will work.

If I remove the date (leaving screenPageviews, sessiona and pageTitel) the query will work.

 

Seems to be an issue with combining pageTitle and date.

 

Query using the Google Analytics 2.0 connector is the same for all three:

 

 

 

= Cube.Transform(#"properties/1",
        {
            {Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}},
            {Cube.AddAndExpandDimensionColumn, "pageTitle", {"pageTitle"}, {"pageTitle"}},
            {Cube.AddMeasureColumn, "screenPageViews", "screenPageViews"},
            {Cube.AddMeasureColumn, "sessions", "sessions"}
        })

 

 

 

 

5 REPLIES 5
Anonymous
Not applicable

@MrsPickles  Have you had any luck being able to fix this issue?  Or connect to a 'custom report' in google analytics 4?

@Anonymous I didn't fix the problem but worked around it by coping the same query that was working in a different pbix. Doesn't make a lot of sense to me as the query was exactly the same but I am happy that it worked.

CoderZen08
Helper IV
Helper IV

Hi @MrsPickles  As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

 

GA4-1.png

 

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:

 

GA4-2.png

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

v-yiruan-msft
Community Support
Community Support

Hi @MrsPickles ,

It's possible that there's an issue with the data in the GA4 property that's causing the query to hang when combining the pageTitle and date measures. You can try to create a custom report in Google Analytics that includes the pageTitle and date measures, and then try connecting to this custom report using the Google Analytics 2.0 connector in Power BI. This will allow you to see if the issue is with the data or with the connector. If the custom report works without any issues, then the problem is likely with the GA4 property. In this case, you may need to check the data in the property to see if there are any inconsistencies or errors that could be causing the issue. You can also try contacting Google Analytics support for further assistance.

Newest 'google-analytics' Questions - Stack Overflow

Best Regards

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

As far as I know there's no way to access any custom reports in Google Analytics with the connector but I'd be happy to be corrected there.

The strange thing is the query loads correctly in the Power Query Editor and I can scroll through all the results, just hangs when trying to apply it.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!