Report stuck in Load - Evaluating

[rodrigorosalesa]

I am lusing the built in connector of google analytics (GA4) implementation 2.0 tom load data to a report. The initial loading keeps getting stuck in this step:

I tried using different versions of Power BI Desktop and all the time I get the same problem. The dataset is not large, around 10k rows. 

Could you please advice me on this? I read only and there is a lot problems like the one I am having. 

Thanks.

[Anonymous]

Hi  @rodrigorosalesa 

What versions have you tested with? Have you used google analytics (GA4) implementation 2.0 to get data before? If you reduce the data to a few hundred rows, test to see if there are problems loading it.

Best Regards,
Community Support Team _ Ailsa Tao

[rodrigorosalesa]

Hey Ailsa, 

Currently I am using version 2.121.664.0, that one gave me the best results. If I reduce the number of rows to around 3k it worked very fast, like 5-8 seconds, so i dont understand why when having more dimensions it gives me problems. 

[Anonymous]

Hi  @rodrigorosalesa 

Desktop has been updated to 2.121.903.0 64-bit (September 2023) . You can update your Desktop version and then load the data from google analytics .

Best Regards,
Community Support Team _ Ailsa Tao

[QueryWhiz]

Hi @rodrigorosalesa Seems like the 2.0 beta connector is still presenting some issues. I hope it'll be fixed soon but since the GA4 connector was developed it's always presented some problems. I had issues many times with my connection or my data. As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options

[rodrigorosalesa]

Hi @QueryWhiz, thankd for your message. I will try to use windsor.ai as a workaround. I will let you know how it goes. 

[Yanskie]

Hi @rodrigorosalesa ,

I do find out the method to solve this problem without any another software or any other plug-ins, and I don't know why it can solve this problem, but it works : ) and it is easy to do:

In "Transform data" which is the M language page, in the table that your have problem with,

add 2 steps:

1. add a custom column which is the copy of a random column(this random column is better not to be text type) in this problem table

2. change data type of the custom column into text data type

load the table, and problem fixed, at least this works for me. cause I had this problem of loading GA4 table and stucked at "evaluating" before I found this solution.

[Robin_Vereijken]

The Solution of @Yanskie worked for me!

[msk_85]

@Yanskie  Thanks man, it worked like a charm

[clemlanoe]

The solution from @Yanskie also worked for me! Thank you!

[Siva_2024]

@Yanskie  That works for me too thanks!