Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.