Appending CSV-Data from Exchange E-Mail

[Hotkey]

Hi there,

i've got some trouble with importing (appending!) CSV Data from an E-Mail account. I receive some report data from an external company as a CSV-attachment by E-Mail every day, containing the information from the previous day.

I managed to automatically fetch the attachment and import the data accordingly. But the previous data gets replaced every day. What i want is to append the new data to the existing one.

Current Query:

https://ibb.co/khauyV

Is there any way to just append the new data? If not with this way: Any other possible solution for the problem?

Thanks in advance and with best regards

Hotkey

[v-yuezhe-msft]

@Hotkey,

Is there any possibility that you put all the files in a folder? In Power BI Desktop, you can connect to the Folder source and once new file is added into the folder, the new data will be added into the existing query after you click refresh in Power BI Desktop. There is a blog for your reference.

https://www.jetglobal.com/blog/power-bi-load-data-from-folder/

Regards,
Lydia