Forum Discussion
warrencowan
11 years agoKudo Collector
Set date range limit on google analytics query
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 w...
- 11 years ago
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.
DavidMoss
10 years agoAdvocate V
Have you tried editing the query in the Advanced Editor. I posted a similar solution here http://community.powerbi.com/t5/Desktop/Power-Query-M-filter-data-by-Dynamic-Date-PQ-not-DAX-Start-of/m-p/55693#M22623