Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Read attachement from encrypted mail

Ist it possible to read an attachment from from an encrypted Mail?

 

I have a working data retrieval query. Now the mails with the attachments have been encrypted due to its content.

 

Now those mails are not listed in the filtered list of mails from the mailbox. I guess it is because of the encryption of the mail.

 

An finally i would guess there is a special step necessary to open those mails (user/pass).

 

Has anybody experience with such a process? Tried some research but didn't find anything suitable.

 

Cheers

Moe

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Do you connect to "Get Data->MS Exchange onlie" with Power BI Desktop?

    Could you show an secreeshot when you connect it with Power BI?

     

    From the email box, can you open the encrypted mail with some kind of credential?

    Is the account logging in email the same as which log in Power BI?

     

    Additionally, please check the "Encrypt-Only option for emails" part in this article.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    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
      7 years ago

      Hi Maggie,

       

      no, i tried to connect by using the normal "MS-Exchange" with Power BI Desktop. Retrying this with "MS-Exchange online" gives the same result. The connection itself works properly and returns the mails from inbox and other folders. The problem is, that encrypted mails are not present in the filtered or unfiltered result (filtering on a sender and subject content -> checked that for correctness more than once).

       

      According to screenshot please let my know which part you need.The code for retreiving the mail is really simple ( personal data changed)

       

      let
    Source = Exchange.Contents("[email protected]"),
    Mail1 = Source{[Name="Mail"]}[Data],
    #"Expanded Sender" = Table.ExpandRecordColumn(Mail1, "Sender", {"Address"}, {"Sender.Address"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Sender", each ([Sender.Address] = "[email protected]")),
          #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each Text.Contains([Subject], "MySearchSubject")),
in
    #"Filtered Rows1"

       

      The Exchange server is an on premise system of my company. Usually an encrypted mail can be opened using our company PKI card certificate with entering a related PIN. Not sure if this could be changed to use normal credentials.

       

      For logging into email i am just providing my mailadress to PowerBI Desktop with no further login information, so i guess PowerBI Desktop uses the account information from my machine.

       

      I read the suggested article, but this is a step futher where i currently cannot get. My first problem ist, that when i am only connected to the mailbox, even without any filter, encrypted mails are not listed in the result. They seem to be ignored for any reason. And i do not see any config option to change this behaviour.

       

      Kind regards

      Thorsten