Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Converting Binary to hex value or numeric value

Hi,   I have Hex Value showing up as a Binary content in PBI desktop (ConversationIndex in MSExchange Attribute object) On expanding this Binary column, I get to see some Unicode characters and no...
APIS and Embedding
Dashboards
Data Modeling
Reports
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    Maybe they aren't hex value or numeric value. You just need a custom column like this.

    Binary.ToText([Attributes.ConversationIndex])

    Converting_Binary_to_hex_value_or_numeric_value

     

    Best Regards,

    Dale

flynt1938's avatar
flynt1938
New Member
7 years ago

Guid.From(Binary.ToText([Binary],1))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

flynt1938 i tried this,,,its converting to same format..but thevalue does not match the original value

  • Aerica_Rishiraj's avatar
    Aerica_Rishiraj
    Regular Visitor
    8 months ago

    Were you able to find solution to this? I am facing the same issue, the conversion won't match the original GUID in Active Directory.