Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lance_6
Helper II
Helper II

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-existent and I can't figure out how to make it work. 

 

Here's roughly what I've got right now: 

 

let
    Source = Binary.Decompress(
                    Web.Contents(
                           "https://testURL.net/history/TestBrotli",
                           [Headers=[Authorization=#"myAPIkey"]]
                                ), 
                    Compression.Brotli
               )
in
    Source

 

 Does anyone have experience with this? Any pointers?

2 ACCEPTED SOLUTIONS
AlexisOlson
Super User
Super User

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.

AlexisOlson_0-1647567981146.png

View solution in original post

v-yingjl
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
v-yingjl
Community Support
Community Support

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.

Thank you. This is frustrating and the other compression functions should definitely be either made functional or removed. 

The language "Compression types include:" doesn't necessarily mean the two listed examples are the only ones that work. There are public documentation pages for compression types Brotli, LZ4, Snappy, and Zstandard. Why do these pages exist if they aren't supported?

v-yingjl
Community Support
Community Support

Hi @lance_6 ,

Currently I have found some information on Binary.Decompress document:

vyingjl_0-1647930294767.png

 

Perhaps it only supports .GZip and .Deflate type in Power Query Editor but not certain. I have submited this issue internal to confirm it(ICM: 296956165), would update here as soon as possible if there is any progress about it.

 

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
Super User
Super User

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.

AlexisOlson_0-1647567981146.png

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors