Receive failure message "evaluation was cancelled"...

Anonymous · ‎09-05-2023

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.

Anonymous · ‎09-12-2023

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.