Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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"}
})
@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.
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:
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:
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.
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
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.