Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combining email data with attachment data

I have linked Power BI to a folder in Outlook. In this folder I receive emails with attachments which have the same headers. For example: email 1 (sender [email protected], time rec 13 Nov 2019 11:02am) ...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    Open the Query Editor and go to the Advanced Editor to see if there is a #"Removed Other Columns1" step, comment or delete this step, then replace #"Removed Other Columns1" in the next #"Expanded Table Column1" with the previous step #"Invoke Custom Function1". Finally, delete the extra columns, the result is as follows:


    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Anonymous ,

Open the Query Editor and go to the Advanced Editor to see if there is a #"Removed Other Columns1" step, comment or delete this step, then replace #"Removed Other Columns1" in the next #"Expanded Table Column1" with the previous step #"Invoke Custom Function1". Finally, delete the extra columns, the result is as follows:


Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks Joey!