topic Re: Is it possible to set up an automated ingest of email attachments? in Developer

Is it possible to set up an automated ingest of email attachments?

hdunnehowrie — Tue, 19 Mar 2024 15:04:35 GMT

We have set up to send to email addresses data from external supplier for usage stats. These are emailed to my inbox very Monday morning and the attachment is .xls format and includes a data of data.

I'd like to set up an automated ingest to PowerBI of this data so that I don't need to manually collate this.

Has anyone done similar to this? I assume I need to set up an Automate flow but I'm new to PowerBI. Does anyone have advice on the best way to go about doing this?

Re: Is it possible to set up an automated ingest of email attachments?

Anonymous — Wed, 20 Mar 2024 05:47:53 GMT

Hi @hdunnehowrie ,

You can use Power Automate to automatically load email attachments in .xls format into Power BI. You can create a flow that is triggered when an email arrives in your inbox, and then use the actions in the flow to save the attachment to a specified location, such as OneDrive or SharePoint. From there, you can use the Power BI connector in Power Automate to refresh a dataset or add rows to a table in Power BI. You can refer the following links to get it.

Official Microsoft Power Automate documentation - Power Automate | Microsoft Learn

"When a new email arrives" trigger

Get attachment

Create table

Add rows to a table

And you can post a thread in Power Platform Community for a dedicated support.

Best Regards

Re: Is it possible to set up an automated ingest of email attachments?

hdunnehowrie — Wed, 20 Mar 2024 06:25:24 GMT

Thanks @Anonymous. Of course, I can send to a SP list! and from there pull into PowerBI. I think I was overcomplicating this be thinking I had to add straight into PowerBI.