Forum Discussion

RahilBukhari's avatar
RahilBukhari
Icon for Advocate I rankAdvocate I
10 years ago

Power BI Desktop connection to SSAS Tabular slow

Hi I'm experiencing unusual behaviour when connecting Power BI Desktop to an on prem Tabular model (2014). Our model has 1000 calculations, any time a user connects to teh Tabular Model, the connect...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

RahilBukhari I can't speak to the slowness, but for the clarification of others looking at this post... I assume one of the following: you mean DAX instead of MDX. Or do you mean multidimensional cube instead of Tabular model?

RahilBukhari's avatar
RahilBukhari
Icon for Advocate I rankAdvocate I
10 years ago

Hi Anonymous

no this is a tabular model and we are seeing "Execute MDX Script" events in the profiler which are the create scripts for each measure that we have.

  • RahilBukhari's avatar
    RahilBukhari
    Icon for Advocate I rankAdvocate I
    9 years ago

    Just as an update, turns out this is a problem in SQL Server 2014 as the underlying architecture would force every connection to first validate the model and it's calculations before allowing the user in, which in our case caused a huge delay and massive load on the server.

     

    In SQL Server 2016, this happens only once and on the first connection after a service restart or process completion.