Receive failure message "evaluation was cancelled" when filter column on GA4 data in power query

[TWMY1014]

Hi All,

I have a report under "explore" section under Google Analytics 4 account, and want to link the data to Power BI (fine with directly link from Power BI desktop or indirectly from dataflow).

However, either way I try I'm facing identical failure message "Evaluation was cancelled" at Power query stage.  The code was in below:

the code run for a long time at line 12 - find all rows that contain specific suffix in weblink.  I'm not sure if it's the query will need to run in every row prior confirm the result and this might be the reason why it fail.

Kindly ask for any solution ? Or other method to connect GA4 data automatically (not manually export in csv as source) to Power BI / service ?

Thanks.

[TWMY1014]

Hi @RM7 thanks.

I also try Winsor.ai, just wonder which stage I can transform the column data (just need exclude 2 keywords and contains 1 sentence in suffix in data field) ?

Thanks.