Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
T_Blanchard
Frequent Visitor

store data from email attachment

I have already set up a query that looks at my Outlook account, and if a specific email is there, copies the attached file (.xlsx) to a lakehouse. This is the video I followed to set this up:  https://www.youtube.com/watch?v=EKPBiCi98cs 

I get a new file each month, with the same columns, but a different month's data. I don't want to have to keep all of these emails in my inbox. Is there a way to get the data to save to the lakehouse without overwriting previously saved data? 

Please keep in mind that I am new to using Fabric, M/Query Editor, etc., so please simplify instructions! 

 

Thanks 

1 ACCEPTED SOLUTION
T_Blanchard
Frequent Visitor

update: I think I have figured out how to do this! 

I noticed the Data Destination option at the bottom in the Query Settings section of the Data Flow. Upon hovering over it, I noticed that the update method was set to 'Replace.' Clicking the gear icon opened another window where I verified the connection credentials. In the 'Choose Destination Target' section, I opted to create a new table within the same Lakehouse, but with a slightly modified name. On the subsequent screen, I selected 'Append' from the update method options at the top, saved the settings, and published my query.

Afterwards, I updated the files in my email account and refreshed the data flow. Upon reviewing both tables in the lakehouse, I confirmed the new table displayed data from both the previous and the updated files.

View solution in original post

1 REPLY 1
T_Blanchard
Frequent Visitor

update: I think I have figured out how to do this! 

I noticed the Data Destination option at the bottom in the Query Settings section of the Data Flow. Upon hovering over it, I noticed that the update method was set to 'Replace.' Clicking the gear icon opened another window where I verified the connection credentials. In the 'Choose Destination Target' section, I opted to create a new table within the same Lakehouse, but with a slightly modified name. On the subsequent screen, I selected 'Append' from the update method options at the top, saved the settings, and published my query.

Afterwards, I updated the files in my email account and refreshed the data flow. Upon reviewing both tables in the lakehouse, I confirmed the new table displayed data from both the previous and the updated files.

Helpful resources

Announcements
August Fabric Update Carousel

Fabric Monthly Update - August 2025

Check out the August 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors