Google analytics 4 data discrepancies

Hi Halkiparis 
According to the official documentation, Google Analytics will only return a subset of values when the date range is very large. If you need more data, you can append multiple queries with different date ranges. If you're not sure what data to return to view, you can also use data event probing to get a quick idea of what to return. To make sure you're seeing the same data you get from Google Analytics, you can run your own queries in Google's interactive tools.
Some users report that reducing the amount of data requested in each query helps. For example, one user solved the problem by pulling only the past month's data and splitting it into multiple queries so that each request only requested 5 days at a time.
Using the data profiling tools - Power Query | Microsoft Learn

Power Query Google Analytics connector - Power Query | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly