Forum Discussion

daniele_tiles's avatar
daniele_tiles
Advocate II
7 years ago
Solved

Decrypt JSON compressed with lz-string

Hi to all,

we have to prototype a dashboard based on a Postgres DB.

The data is saved in JSON format, but unfortunately is also compressed with lz-string:

 

Has anyone experienced this before? Is there some function to call, or should I make a python script and call it?

Best regards

 

Daniele Tiles

Need Help

4 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi daniele_tiles ,

     

    Maybe you need to decompress fist.

     

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

     

    Best Regards,

    Amy

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

      • Sairam_V's avatar
        Sairam_V
        Frequent Visitor
        3 years ago

        If possible, Can you please share the python code to Decrypt JSON compressed with lz-string for the column mentioned.