Forum Discussion

Regular Visitor

3 years ago

Solved

Update a query with a new data set for previous month without need to read all previous month data

Our ERP system continuously creates a .csv file with entries for each user instance, and it's approximately 50 MB each month. I remmove the file from the ERP system where it is generated, and use Po...

amitchandak
3 years ago
pnoteng , I think it should be a append not merge

you can use option like this with folder

https://exceleratorbi.com.au/load-the-latest-version-of-a-file-in-power-query/

or check DAX append

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/

Icon for Super User rank

Super User

3 years ago

pnoteng , I think it should be a append not merge

you can use option like this with folder

https://exceleratorbi.com.au/load-the-latest-version-of-a-file-in-power-query/

or check DAX append

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/