Forum Discussion

lance_6's avatar
lance_6
Helper II
4 years ago
Solved

Decompress Brotli Data

I'm working with an API that delivers payloads compressed using brotli. I've been looking for documentation on decompressing this in the Power Query Editor. Microsoft's documentation on this is non-e...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    It seems like the Compression.Brotli argument isn't even implemented. I can't get it to work with a test example from here, even when entered in the most basic form.

  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi lance_6 ,

    Like I guessed, it only supports the two types which are introdcued in the document, here is the update from PG team:

     

    This is working as documented, the only compression types supported are as documented. Using any other types throws the appropriate Invalid compression type. 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

It seems like the Compression.Brotli argument isn't even implemented. I can't get it to work with a test example from here, even when entered in the most basic form.

  • lance_6's avatar
    lance_6
    Helper II
    4 years ago

    This is the same thing I found. Looks like although they have the `Compression.Brotli` function, they don't have it implemented and only accept the two options v-yingjl mentioned. Compression.GZip and Compression.Deflate

     

    I'm not sure why they would have the functions and not allow for them to be used. Very frustrating, Microsoft being Microsoft.