Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Google analytics not importing all data

Hi all,

 

When I run a data import for Google Analytics, it's only pulling tiny subsets of data (almost like a sample). 

 

Are there any known issues with the connections anyone is aware of? Or a setting that prevents the import from pulling the full data set?

 

Thanks

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

In Power BI Desktop, the built-in Google Analytics connector relies on Google Analytics Core Reporting API. Please review this article to check if you can combine Gender dimension and Sessions metrics using Google Analytics Core Reporting API.

In addition, for the difference between Google Analytic report and Power BI report, please check product team's response.

"The API we're using for Google Analytics is the one available to free users, and that API is known to return less accurate values for high volume sites due to the way it samples data. Unfortunately, the API for Google Analytics Premium customers is significantly different than that for the free users, so we'd need to implement a new connector specifically for Premium in order to get the more accurate values. This is not currently on our roadmap. Customers who would like to see this feature should request it or upvote it (if already there) at ideas.powerbi.com."

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

1 REPLY 1
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

In Power BI Desktop, the built-in Google Analytics connector relies on Google Analytics Core Reporting API. Please review this article to check if you can combine Gender dimension and Sessions metrics using Google Analytics Core Reporting API.

In addition, for the difference between Google Analytic report and Power BI report, please check product team's response.

"The API we're using for Google Analytics is the one available to free users, and that API is known to return less accurate values for high volume sites due to the way it samples data. Unfortunately, the API for Google Analytics Premium customers is significantly different than that for the free users, so we'd need to implement a new connector specifically for Premium in order to get the more accurate values. This is not currently on our roadmap. Customers who would like to see this feature should request it or upvote it (if already there) at ideas.powerbi.com."

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.