Forum Discussion

Ah43013's avatar
Ah43013
New Member
3 years ago

Data refresh - How to upload and format with CSV

I get a "blast" data report via excel in a CSV format. It has the same data and format but each day i get it, it adds info from the preivous day.  How can i automate the upload process and not dup...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Ah43013 , Unless you configure incremental(That too will work service refresh). it would replace data with the new ones.

if the new one only has new data and you want to 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/

 

 

I am not very clear why you need delete duplicate