Forum Discussion
Aggregating daily table in direct query & filtering last 30 days
Hi
I'm connecting by direct query to google bigquery to a daily table ( ~1m rows per month)
I want to create 2 tables from it, 1 daily on last month and 1 monthly on last year:
1. How can i auto filter it to last 30 days ?
2. How can i create an aggregated monthly table without quering all the millions of rows ?
Thanks
1 Reply
v-juanli-msftCommunity Support
Hi Anonymous
You could filter data in Power query or use query parameter.
References:
https://powerbi.microsoft.com/sv-se/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-restrict-data-in-query-editor/td-p/406415
https://community.powerbi.com/t5/Desktop/Limit-import-based-on-date/td-p/294485
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.