Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Appending CSV-Data from Exchange E-Mail

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    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