Forum Discussion
RahilBukhari
Advocate I
Advocate IPower 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...
RahilBukhariAdvocate I
Advocate IHi 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.
RahilBukhariAdvocate I
Advocate IJust 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.