I have a sales dataset of over 4years and the row counts is in some millions. There is a chance of this count increasing to billions in future. So, when refreshing every time, the model refresh is taking lots of time just to import the data. How can I solve this? Is there anything in Power BI, just to import the recently added/updated data without importing all historic data ? If yes, please let me know how to achieve that.
Thanks in advance.