Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sunkari
Responsive Resident
Responsive Resident

Difference between live connection and direct query mode

what the difference between live connection and direct query mode?

1 ACCEPTED SOLUTION

@Sunkari 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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2

@Sunkari 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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
ankitpatira
Community Champion
Community Champion

@Sunkari Live connection or DirectQuery are essentially same thing. 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.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors