Google Analytic Connector: Passing Start_date and end_date the input to the API

[bubbletao]

Hello Experts,

I am currently using the Google Analytics (GA) connector to pull data from GA, and combine it with other data source to create the dashboard. 

My challenge is I won't be able to pass on the start date and end date parameter via the native connector. My GA dataset is very large and I only need L30days of data, instead of pulling all 6+ years of history every time I click refresh.

In my previous company, I was able to use these two parameters in DOMO, but I can't find it in PowerBI.  Can anyone help me here ?

[v-joesh-msft · Accepted solution]

Hi @bubbletao ,

Maybe you can use parameters to specify the date range you want, refer to the following document:

Using Query Parameters in Power BI Desktop

Best Regards,

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

[bubbletao]

Hi @v-joesh-msft   I was able to create the query parameter to meet my need. Thanks !

The video https://www.youtube.com/watch?v=twBUmqVOGgg is particularly helpful for hands on step by step instruction. Anything who has the same issue you can create the start_date and end_date parameters following the video here.