google analytics filtering date : first request

[noliverte]

Hello,

I want to pull data in Powerbi from my web site using Google analytics connectors.

I choosed all my datas based on date (and other fields...), but it took too much time...

And i needn't all dates (just one year)

How can I select a specific date range while the first request to reduce loading time ?

I 'd like to specify these dates range at the first connection.

I read some articles to apply a date filter, but it's always after the first load.

A response would be appreciated.

Noliverte

[v-yingjl · Accepted solution]

Hi @noliverte ,

I haven't found any options to setting filters for google analysis connector, I'd like to suggest you to use google analytics api to instead.

Reference:

1. Google Analytics Filters 
2. Core Reporting API - Reference Guide 

You can also refer these simliar issues that could help you:

1. Increase Date Range of Google Analytics Content Pack 
2. Apply filters to Google Analytics query URI in Power BI 
3. Set date range limit on google analytics query 

Best Regards,
Yingjie Li

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