Forum Discussion

BillyT_350's avatar
BillyT_350
Helper V
8 years ago

Microsoft SQL Server Analysis Services process killing my computer's memory

And it has nothing to do with data pulls, so far as I can tell. This is occuring with a pulled dataset, and I'm simply messing with measures and visuals. I've been working on a complex report (lots ...
Need Help
RogerSteinberg's avatar
RogerSteinberg
Post Patron
5 years ago

I had the exact same issue and my problem came from complex ranking calculated columns and measures. Once I removed them and applied the ranking formulae within my sql query the error disappeared. To be honest, this is really bad on Power BI ... Why would my entire CPU and memory be eaten up by ranking measures... I have 16gb of RAM btw

  • clozano's avatar
    clozano
    Frequent Visitor
    5 years ago

    Same problem too! 😞

     

    Microsoft is extremely disappointing and power BI is dying from its success.

     

    This is a great pity.

     

    Microsoft makes frequent updates without doing the necessary tests beforehand, with the result that what was working doesn't work anymore and all the reports of a company become unusable.

     

    This is simply shameful for Microsoft!

     

    I'm very angry because a company of this size cannot do that and implement updates without testing them.

    The On-premises data gateway hasn't worked for several weeks now and the dates are pushed back from day to day... and this despite the latest version installed.

     

    Shameful!