Forum Discussion
Need help appending new rows to existing rows when refreshing with a date component
I would like Power BI to perform a daily refresh of an Excel file. However, during the refresh process, I want it to avoid updating the existing values in the file and instead add new rows from the E...
rubayatyasmin
Community Champion
Community Championhere is another idea, though this could be a workaround.
- Duplicate your base query.
- then in the duplicated query remove the steps that modify existing data or any operation that you want to avoid during the refresh.
- Create a new query that loads data from your Excel file.
- Remove the rows with orders that have been fulfilled or any unwanted data.
- Add a custom column that contains the current date using the formula DateTime.Localnow().
- Then in the duplicated query append the newly created query.
- then in power BI service schedule a daily refresh in the dataset
I am not sure if this would work because it would mean I would have to remove/add rows with completed/new orders every day.