Forum Discussion
Google Analytics - data gap
not sure if this is the issue you are seeing, but this thread is worth a read:
Hi,
you are facing an issue of sampling. So Power bi's connector for google analytics has a sampling issue and an API Calls limit. The standard limitations and quotas for Google Analytics API requests are documented in Limits and Quotas on API Requests. However, Power BI Desktop and Power BI service allow you to use the following enhanced number of queries.
Queries per day: 1,500,000 Queries per 100 seconds: 4,000
Might be better to connect Google analytics to a data warehouse such as Google BigQuery, which will help you get access to historical data that you won't be able to get with Power bi's connector. I'd suggest using a third-party connector such as windsor.ai, they also have a ready & free templates ( https://appsource.microsoft.com/en-us/product/power-bi/windsorgroupgmbh1585043281642.media_overview_report?tab=Overview)
The issue being described is the user count is higher in power bi than is presented on Google Analytics site. I have done a bit of research on why that might be and I have run across several sources which use windsor.ai and or BigQuery to get data into power bi. I don't know how the API limitations would result in inflation of users I would think less users would show up in Power BI. One topic which I believe could be causing the gap or inflated numbers in power bi is Thresholding in GA4 I would consider that a possible reason for the numbers in the GA site to be less than the numbers in Power BI which aren't impacted by thresholding which is Google filtering out rows to protect the users privacy.
