Forum Discussion
Incremental data load using Power Query, append new records to existing table
Is there a work around for the Power BI Pro users to do incremental refresh of data? Would there be M code or R scripting that would read existing tables and only append or update records, rather th...
Hi steph_io
sorry, that was the wrong link. Just create the code in PBI Desktop and copy it to dataflows like described here: http://excel-inside.pro/blog/2019/03/21/classical-incremental-refresh-for-cloud-data-sources-in-power-bi-service-for-pro-accounts/#more-366
Hi
Thanks to ImkeF for providing such useful solutions.
Although it has some limitation, it may be helpful for many cases and provides many useful techniques.
Best Regards
Maggie