I am importing data from Google Analytics and one other source. When building the report, everything imported fine. However, after setting up auto-refresh daily most of the rows started duplicating.
I am able to fix this with a remove duplicates transformation. This seems like a workaround to the underlying problem. Is there any reason my data may be duplicating?
For duplicating records in google analytics, you could try to modify this in google analytic to see whether it works or not. You could try to refer to Duplicate Transactions In Google Analytics - The Check And The Fix for details.
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!