Incremental refresh for two sources with append query

[PowerBI_Mallow]

We have three years of business data now, recent 2 years of data will always in the mysql database and other years will be stored in sharepoint (currently 1 year data) on the next year in sharepoint there will be 2 years of data and in mysql database there will be 2 years of data, it will be continuing.

No we want to append both the data from mysql database and sharepoint. I would like to import sharepoint and incrementally refresh the data from mysql database is it possible. 

please provide your suggestion on this.

[lbendlin]

what prevents you from storing all the data in the SharePoint?

[PowerBI_Mallow]

@lbendlin , we are having the sql db for connecting with web application. we have planned to purge data from main db and storing the purged data in sharepoint