Forum Discussion
What is the difference between creating reports on Live Connection and in a Direct Query Mode?
Why can we create calculated columns in direct query mode but not in live connection?
Hi Anonymous ,
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.The difference between them as below:
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.
For more details, you can read related document.Data refresh in Power BI - Power BI | Microsoft Docs
Live Connection; When Power BI comes Hybrid - RADACAD
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , I case of live even meta data is controlled by the source. That is why you you can only create measure not column
refer
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Also check power bi dataset direct Query
https://radacad.com/directquery-for-power-bi-dataset-how-does-it-work
v-henryk-mstfCommunity Support
Hi Anonymous ,
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.The difference between them as below:
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.
For more details, you can read related document.Data refresh in Power BI - Power BI | Microsoft Docs
Live Connection; When Power BI comes Hybrid - RADACAD
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
