Solved: Set date range limit on google analytics query - Page 2

warrencowan · ‎07-25-2015

Does anyone now how to set the date range for the Google analytics connector in Power Bi desktop.

Its a very powerful connector but when I create a query, it pulls it back all rows for all time which goes back 2.5 years.

Its nice to know I can get that if I need it, but its massive overkill for a last 30 days analysis on sales and makes for huge, slow and unwieldy data sets.

I just cant see a date range limiter in the connector, or figure it out in the advanced query editor!

Anyone got any suggestions?

Thanks in advance, Warren

andre · ‎07-25-2015

When you bring the Time attribute in your query, you have the ability to right click on the time field and specify the filter condition (Before, After, etc.) after the filter has been applied you can click on a gear box next to the Filtered Rows step in the Applied Steps section on the right and tweak it if you need to.

View solution in original post

Set date range limit on google analytics query

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024