how to enable Gzip Compression for Excel xmla requests? (MSOLAP and HTTP) RRS feed

  • Question

  • Hi, I really don't know in which Category I should post this Question : Please feel free to move it in case it needs.  Thanks for your comprehension.


    I'm using an xmla server which answers correctly with GZIP compression to http request when using a web browser.



    When using excel to query on the same (local) server thru MSOLAP.6, everything works correctly, but there is no GZIP compression. (no compression at all)

    I tried to add

    Transport Compression=gzip

    to my connection string as mentionned here :

       <odc:ConnectionString>Provider=MSOLAP.6;Persist Security Info=True;User ID=admin;Data Source=;Initial Catalog=Sales;MDX Missing Member Mode=Ignore;Protocol Format=XML;Transport Compression=gzip</odc:ConnectionString>

    but, doing this, I get the following error while tring to connect Image(Failed to initialize data source)

    Is it Excel which does not manage compression (GZIP or other) with http requests ?

    Is it the connector ?  (I use Provider=MSOLAP.6

    As a workaround, can we imagine to intercept http requests and (mostly) their responses using VBA ? in that case, I could receive compressed data, and decompress them "on the fly"...

    Thanks in advance for your answers, ideas, advices.


    Wednesday, August 7, 2019 5:00 PM