Forum Discussion
Helper IAutomate Power BI report
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
Resident RockstarHi 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