Showing results for 
Search instead for 
Did you mean: 

Report intercativity is very slow from powerBI - SSAS Model



I have preapred a report in power bi desktop which connects to the SSAS tabular model which is residing on the on premise server. It works fast in power bi desktop.


however when I publish to, and do intercativity from there it is very slow. What and all the steps to improve the performance. It looks like there is no difference connecting a SQL server tavle in direct query and also the live connection of a SSAS tabular model.


Enterprise gateway is installed on my desktop. SSAS model is on the server (on premise)





ankitpatira Super Contributor
Super Contributor

Re: Report intercativity is very slow from powerBI - SSAS Model

@shamsuddeenvp Connecting live to SSAS tabular model from would also depend on the network connectivity. When you interact with visual on report it send queries via gateway to be executed on on-prem database and result gets returned back. So it may get affected by your network connectivity. In powerbi desktop you are connected locally to on-prem data source and therefore you're seeing performance difference. 

Re: Report intercativity is very slow from powerBI - SSAS Model

Thanks @ankitpatira for yuour reply. 


This  I am clear that Power BI desktop it directly connect and of course it will be faster.


My query is that why  I couldn't see any improvement in performance if I connect SSAS tabular model with respective to connecting SQL tables directly.


Since SSAS tabular model is inmemry and should pull the data fast right. If there is no improvement in performance, doesnt make sense to build a cube, instead directly connect to SQL tables.


Please correct me if I am wrong. 




Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)