Report drilldown seizing SSAS (multi) server

[RyanAck]

Hi everyone, we've been hitting an issue tied to drilldowns in matrix visuals that consume all the processing power of our SSAS server. As a result, if one person tries to drill down, our cubes freeze for everyone else in the company. It is devastating. 

Our cubes are multidimensional SSAS. The reports are live connections and contain a fair level of detail and go to a low grain if drilled into. 

Example: 

• Customer
  • Gender 
    • Product
      • Date
        • Product Size

I have to imagine others have seen this problem. It was very difficult to trace the sessions back to the Power BI reports, but we did it. The resources seem to be struggling with the SUMMARIZE function with multiple drill down levels in a hierarchy. 

Has anyone else run into a similar situation? 

Thank you for reading and I appreciate any insight. 

[v-piga-msft · Accepted solution]

Hi @RyanAck,

If I understand your sceanrio correctly that you have a report with multidimensional SSAS and you create a matrix with Drill down in Power BI, when someone tries to drill down in the matrix, your cubes will freeze for everyone else in the company?

I haven't seen this issue before. I'm afraid this issue may be not caused in Power BI. I suggest you could use SQL Server Profiler to have a trace for this issue in SSAS when you drill down in matrix.

Best Regards,

Cherry

[RyanAck]

Thank you for your feedback. We will look into the profiling. I had to imagine it would be a much bigger issue if it wasn't just us.

Thank you!