Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 150 | |
| 126 | |
| 109 | |
| 79 | |
| 54 |