connect data present on Email with power bi desktop

[Anonymous]

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.

[v-rzhou-msft]

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]

@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.

[Anonymous]

@parry2k I tried to detail my question. Pls have a look. Thanks!