Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Friends,
I would like your help regarding the following request.
I would like to set up a BI solution to analyse the emails that our company receive on generic mailbox.
The fields needed are :
1. Sender adress
2. Recipient adress
3. Date email sent
4. Email unique ID
5. N° of Attachment received by email (based on original email ID)
6. Format of attachment (PDF, JPG,..)
I would need to keep historical data to make comparison with previous year/month/week…
Is is feasible ? For my colleagues it is not possible to collect attachment figures.
Any advise to share on this topic ?
Many thanks in advance.
Regards
Solved! Go to Solution.
Hi @AUz
For this, I think you should explore Power Automate first. That will help you collect that information and then store it in SharePoint or Excel and then you can analyze that data into Power BI.
Dear Ankit,
Many thanks for your quick insights.
I am afraid I am not familiar with Power Automate.
Are you able to detail a bit more how you are suggesting to use it or any useful article you can recommand ?
Thank you & Regard, Auz
Hi @AUz
Pls check this.
https://www.youtube.com/watch?v=x5l7Ow7s5Lo
Hi @AUz
For this, I think you should explore Power Automate first. That will help you collect that information and then store it in SharePoint or Excel and then you can analyze that data into Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.