Decoding drag and drop rank field from Rally API

[Anonymous]

I know this is a pretty specific situation but I am at a dead end trying myself. I have a rally API connection within power BI that pulls through all of the fields for my portfolio items. I want to display them in their drag and drop rank order but unfortunately drag and drop rank is encoded and appears like this "O~[.*3FnP]9g-UY??l(_AJ%~@Q%WEK,t+rDcPv"}xKJ'D;?XVB>^t;C5'9VjX3qx"

Has anyone had any success decoding this column in power BI? My first thought would be a python script within BI but I am not that advanced with python to create such a script. 

I did find an online document explaining the encoding if it is helpful: 

https://knowledge.broadcom.com/external/article/47752/rally-interpret-draganddroprank.html

[Anonymous]

Hi @Anonymous 

You need to know the implementation details of rally's encoding in order to decode it properly and convert it to numeric values.

Assuming that the rally encoding is some known custom encoding format, you can decode it by understanding how it encodes and decodes.

Regards,

Nono Chen

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

[Anonymous]

@Anonymous 

I think the details are explained in the article I linked: https://knowledge.broadcom.com/external/article/47752/rally-interpret-draganddroprank.html

I am not capable of turning this into code to decode it though.