Forum Discussion

tmhrzgr's avatar
tmhrzgr
Frequent Visitor
4 years ago

Accessing Exchange User Properties

Hi all,

 

today I try to convert some old reports (fiddling with Excel, VBA, all the old stuff, you know... ;)) into a new, more accessable Power BI-report. One part of this report is to provide informations about e-mails located in a Office 365 shared mailbox. For that I use the Exchange Online-connector.

 

Some parts of the relevant informations are stored in own defined UserProperties, which I can access via Outlook Desktop. Sadly I'm unable to find any stored values of own UserProperties in Power BI via the connector.

 

There are hints of the UserProperties (for example, the headers of the UserProperties seem to be available when i deep dive into the raw data at Attributes records -> ExtendesProperties records -> PropertyDefinitionStream -> convert to text), but somehow the values of the stored informations are nowhere to find.

 

Did anyone already successfully accessed this data?

 

Thanks für you help!

Tom

Need Help

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    Hi tmhrzgr ,

     

    Based on my test, When you select the mail table, please click Edit go to Query Editor. You can find the column named Attachments and Attributes, please expand contained columns. See if there are any attributes you need

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • tmhrzgr's avatar
      tmhrzgr
      Frequent Visitor
      4 years ago

      Hi V-lianl-msft,

       

      thanks for your quick reply. Sadly the searched values aren't stored in Attachments and Attributes. 😞

       

       

      Greetings,

      Tom