Forum Discussion

Fcaill's avatar
Fcaill
New Member
3 years ago

Live connection vs Direct query performance

Hi, I have a SSAS cube that is slow. We need to optimize it but it requires a big effort.  We migrated it to Power BI Premium but the performance was the same. Then I tried to connect to the datase...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Fcaill ,

Both connects to your on-prem data source and keeps connected so when you interact with your visuals queries are sent to on-prem and results returned back are updatd in visual. You can do further reading here to understand difference between Live connection / DirectQuery and Import.

 

Another thing to note in difference. Live Connection refers to connecting directly to a Model (SSAS Multidimensional or Tabular) in this regard, all your modeling work is done on those. With Direct Query - you are connecting to a database, and you have the ability to create calculated columns and measures in Power BI. So, Power BI serves as your model layer, while still keeping your data in your databases.

 

Using DirectQuery in Power BI - Power BI | Microsoft Learn

Power BI Deployment. Import v Direct Query v Live Connection — Clearly Solutions

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly