January 8, 2021
The databases I access are cumulative and contain an ever increasing number of records. They never change after being entered.
My PowerBI queries download the whole database every time I refresh, when what I would really like is to download only the "new" records since my previous refresh, based on a date/time stamp in each record or simply recording the date/time of the previous refresh. Does anyone know a way to achieve this for sequel databases, excel worksheets etc?
In the same vein of saving download time and filesize, the sequel databases contain many more fields (columns) than I need. Is there a way to request only the fields I need?
I have searched this forum and cannot find any info on this subject.
Thanks in advance,
July 16, 2010
You can use Incremental Refresh.