create report in powerbi using outlook attachments

[pasupathi]

Dear Helpers

datasource is outlook from that i need to create report in powerbi
in outlook excel attachements are there. for every 15 min one excel file will generate in a hour totally 4 excel files will generate in day 24*4 = 96 files in a day. these files has to appened automatically on that we need create report
note: same columns and same data types are there ( so i choose append option)

Regards
Dilip    

[v-jingzhang]

Hi @pasupathi 

Have you tried the solution from the link Amit has shared? It should work. When you have filtered all needed files in the table and combine files in AttachmentContent column, they will be combined into one query automatically. You don't need to append queries then. 

Best Regards,
Community Support Team _ Jing

[amitchandak · Accepted solution]

@pasupathi , refer if this can help

https://radacad.com/import-email-attachments-directly-into-a-power-bi-report-using-power-query