Forum Discussion

asmith's avatar
asmith
Regular Visitor
11 years ago
Solved

Does the Google Analytics connector bring in full data or sampled data?

This might seem like an odd question but does anyone know if the Google Analytics connector brings in sampled data or complete data? On large websites, Google will sample data to lessen data pull loa...
adelheni's avatar
adelheni
Icon for Helper III rankHelper III
4 years ago

Hi,

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.