Forum Discussion
Sorting issue in Power Query editor Combine files
Hi Anonymous ,
The following two articles describe in detail how to extract attachments from emails, you can follow the steps in the articles and try them step by step based on your own email:
https://radacad.com/import-email-attachments-directly-into-a-power-bi-report-using-power-query
https://blog.crossjoin.co.uk/2018/06/01/email-attachments-power-bi/
Wish it is helpful for you!
Best Regards
Lucien
- Anonymous5 years agoNot applicable
Hi Lucien,
Thank you for the response.
I tried following the steps mentioned in below article again now and i am facing same issue. Infact i used the below as reference when i initaly did report few months back. It worked fine untill few days back and it was failing when i had to refresh another data file is same PowerBI file.
https://radacad.com/import-email-attachments-directly-into-a-power-bi-report-using-power-query
Now i created new PBIX file only to extract attachments by following exact steps mentioned in article above, but not sure why as soon as i remove other columns it is not the latest email anymore.
But, I tried not using "Removed Other Columns" step and expanded the attachment in same row and content of latest email attachment is extracted now.
Thank you once again.
Regards,
Koushik.