Re: connect data present on Email with power bi de...

Anonymous · ‎12-20-2021

How to connect data present on Email with power bi desktop and service? I want to do this process, again and again, similar data transformations, similar reports..so how I can automate this? Also, I do not want to use any individual or employee's email id.

Anonymous · ‎12-22-2021

Hi @Anonymous ,

I think you can try Microsoft Exchange connector in Power BI to connect to mail application like outlook.

The Exchange online data source in Power BI desktop can retrieve data about the attachments and size. When you select the mail table, please click Edit go to Query Editor. You can find the column named Attachments and Attributes, please expand contained columns.

After you get data as you want, you can upload the latest data by refresh option.

For reference:

PowerBI - Get data from Exchange- Inbox details(size of the mail,attachments etc

Import Email Attachments Directly Into a Power BI Report using Power Query

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k · ‎12-20-2021

@Anonymous your question is not fully clear, can you provide bit more details. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 is not fully clear, can you provide bit more details.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.