Google Analytics 4 to Power BI Data Load and transformation

[hematandon]

Hi,

I'm trying to extract engagement data for 2025 from GA4 into Power BI. When I run the query for just one month (June), everything works smoothly. However, when I modify the query to retrieve data starting from January, the process becomes extremely slow — it just keeps running indefinitely.

All I'm doing is pulling data from GA4, adding a couple of columns (Year and Month), applying filters (including one on pageLocation), grouping by all columns, and summarizing by event count.

Despite this, the result is only 51 records with 7 columns — nothing that should be causing such a lag.

Any quick advice or solution would be greatly appreciated, as I need this urgently.

Thanks!

[pankajnamekar25 · Accepted solution]

Hello @hematandon 

You can try these options

 GA4 API is slow for large date ranges

 Apply filters (like pageLocation) early in Power Query

Grouping on unfiltered data causes delays

 Native GA4 connector has performance limitations

 Use BigQuery for faster, scalable access

 Break data load by month and append later

Use Table.Buffer() before grouping if needed

Disable "Enable Load" for intermediate queries

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-echaithra]

Hi @hematandon ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[v-echaithra]

Hi @hematandon ,

Thank you @rohit1991  for sharing your inputs.

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[rohit1991 · Accepted solution]

Hi @hematandon 

Looks like you've already got some great suggestions above. Just to reinforce a few practical points from my side that have helped in similar GA4–Power BI cases:

• The GA4 API slows down significantly for longer date ranges batching by month (as you're doing) and appending incrementally usually helps.

• Be sure to apply filters early in Power Query, ideally before any grouping or column adds.

• GA4’s connector has known performance bottlenecks. If possible, consider staging via BigQuery and then importing to Power BI for smoother scaling.

• Also try using Table.Buffer() before complex transformations, and disable loading of intermediate queries.

If none of this improves performance, test a sample load with a smaller unfiltered dataset and slowly layer transformations back in that often isolates the culprit.

[v-echaithra]

Hi @hematandon ,

May I ask if you have gotten this issue resolved?

If it is solved by @pankajnamekar25 , please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[pankajnamekar25 · Accepted solution]

Hello @hematandon 

You can try these options

 GA4 API is slow for large date ranges

 Apply filters (like pageLocation) early in Power Query

Grouping on unfiltered data causes delays

 Native GA4 connector has performance limitations

 Use BigQuery for faster, scalable access

 Break data load by month and append later

Use Table.Buffer() before grouping if needed

Disable "Enable Load" for intermediate queries

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.