How to get the data

[Anonymous]

Hi Everyone

           I have already 7 core data in that datasource. day to day coming 40000 data are coming. but am using that  mysql Datasource. so how to get that all data. if any possible please share to me

[amitchandak]

@Anonymous , Not very clear. Are you looking for incremental load ?

Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[Anonymous]

Hi

   I know about incremental refresh but my client want 2018 to still now data. so which connection we are use?.

[amitchandak]

@Anonymous , You can bring the past data to a new table and append that to an existing table.