none
SSAS sources does not create mdx susbset statement anymore RRS feed

  • Question

  • Hello,

    Strange behaviour from recent powerquery update, my SSAS sources upon cubes does not conains any susbset statement anymore (It use to have such subset in the preview AND in the gloabl load) ???? As a result  poor performance, and infinit refresh time :-(

    Does anyone have the same issue ?

    Note : Power bi Desktop still provide subset mdx in data retreive.

    Regards




    • Edited by fpatou Friday, June 17, 2016 2:14 PM
    Friday, June 17, 2016 1:10 PM

Answers

All replies

  • Hi,

    Both Power Query and Power BI will page over the data in 4096 increments. Are you not seeing a SUBSET call with 4096 as the size? I'm looking at both Excel 2016 and Power BI Desktop and they appear to do this as expected.

    Thanks,
    Tristan St-Cyr

    Friday, June 17, 2016 10:22 PM
    Moderator
  • Hello, thank you for your feedback....

    Just to be sure are you using the 64 bit excel and power query add-in ? what is you version ?

    I've test it with some of my colleagues running 64/32 bit and still no paging subset for MDX....


    Regards


    • Edited by fpatou Monday, June 20, 2016 8:30 AM spelling
    Monday, June 20, 2016 8:03 AM
  • Sorry about the late reply.

    Can you use the "Send a Frown" feature? We'd need to follow up over email with some product traces to diagnose the issue further.

    Wednesday, July 6, 2016 2:35 PM
    Moderator
  • hello ! thank you i have just done it right now ! hope to have feedback soon

    Regards

    Wednesday, July 20, 2016 12:44 PM