Forum Discussion
Append Historical data with current data without overwriting
Dear Experts, i am in a problematic situation related to historical data and new data. i will explain the scenario below: we have a historical data which we will load till Sep 2021 one time (...
mahoneypat is there any suggestion how do we get the export working? so you mean to say we export the most recent month or current month data and export it as soon as the month is finished. Our objective is simple, current data should get added to historical data as soon as the month or day is finished, whatever way is fine.
The simplest way would be to use DAX Studio at the end of each month to export the month of data as CSV or Excel. You can then store the monthly files on SharePoint (for example) and then append your original data, the monthly files to date, and the current month REST API data.
Pat
