Forum Discussion
How to Import data for latest date or Apply dynamic filters during data refresh
Hi I have a data set that contains 6 months of data in table storage. Data is added on the table on a daily basis. I want to add a dynamic filter during import which will pick data from the las...
As long as you add this formula before expanding your table, it will work.
Hi,
You can try incremental refresh
Configure incremental refresh for Power BI datasets - Power BI | Microsoft Docs
Thanks,
Shanthakumar.
=Table.SelectRows(Table,each DateTime.Date([TimeStamping])=DateTime.Date(DateTime.LocalNow())