Forum Discussion
Read attachement from encrypted mail
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.
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