Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Anyone, please help me on below:
In my organization, I will receive daily report (with history) from various locations in different excel file formats through outlook attachment. Please suggest the best method to automate those reports to view the results in Power BI. I am currently using PPU trial version.
In short, I want to use mail attachments(excel format varies from location to location) for as data source, keep the latest file, transform the latest file as per my requirement, visualize in Power BI server through automating the process. Thank you for your support in advance!
Solved! Go to Solution.
Hi @sriramk
Power Query is your friend here. With this you can connect to an Exchange account, filter out the email you want, open the attachments and load that data into the Data Model. This won't be licence-specific, anyone with a Pro licence upwards will be able to do this.
If you don't know Power Query there is quite a bit to learn, but these should give you a start.
Import Email Attachments Directly Into a Power BI Report using Power Query - RADACAD
Using PowerQuery with Email - The Excelguru BlogThe Excelguru Blog
Remember there is also a Power Query specific forum you can ask question in if yoiu need it.
Hope this helps
Stuart
Hi @sriramk
Power Query is your friend here. With this you can connect to an Exchange account, filter out the email you want, open the attachments and load that data into the Data Model. This won't be licence-specific, anyone with a Pro licence upwards will be able to do this.
If you don't know Power Query there is quite a bit to learn, but these should give you a start.
Import Email Attachments Directly Into a Power BI Report using Power Query - RADACAD
Using PowerQuery with Email - The Excelguru BlogThe Excelguru Blog
Remember there is also a Power Query specific forum you can ask question in if yoiu need it.
Hope this helps
Stuart
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
13 | |
8 |
User | Count |
---|---|
50 | |
39 | |
32 | |
16 | |
13 |