Forum Discussion
Solved
Filter table in Power Query to bring only for Today data
Hi, I have a fairly simple task that I am trying to do. I have multiple table in power query. But one of the table has 30mil rows of data. I do not need that many data to be pulled in to report. I ...
Pull the arrow down on your Date column and in Date Filters choose "Is Latest". Depending on your data source, it may "fold" back to your source and return data quickly (vs. loading all 30M rows and then filtering).
Pat
Do you know if
= Table.SelectRows(#"Changed Type", each ([Date] = DateTime.Date(DateTime.LocalNow())))
Would also work with query folding? Just thinking filter by latest would pull yesterdays results if no data was entered today?
Do you know if
= Table.SelectRows(#"Changed Type", each ([Date] = DateTime.Date(DateTime.LocalNow())))
Would also work with query folding? Just thinking filter by latest would pull yesterdays results if no data was entered today?
I will give it a try.