Forum Discussion
Data Source: An e-mail
An Excel file gets e-mailed to me every Friday. The format is exact, it just has updated data. I don't want to open the e-mail at all. I want Power Bi to grab the new data and change my Dashboard visuals when I re-fresh. Can the Excel file go automatically to a OneDrive folder? Hope this helps.
i think that is outside of the bounds of what power bi does. however you can probably use power automate to do that https://powerautomate.microsoft.com/en-US/templates/details/289f7f75e2ff4a3183cfd08064bdece6/save-email-attachments-to-the-file-system/ or https://www.multcloud.com/tutorials/power-automate-save-email-attachment-to-onedrive-5555-gc.html and then process it with power bi as i have stipulated by just dumping the file to a folder and then processing the folder in power bi rather than the file and setting up an automated update.