Forum Discussion
Direct Query/Import Mode/Live Connection questions
Hi pennyhoho117 ,
Thank you for your response.
In Live connection, data is not imported into Power BI, it remains in the external data source and data is pre-modeled like SSAS.Where in DirectQuery, data is also not imported into Power BI, it remains in the underlying relational database like SQL Server and it does not require pre-aggregated data in the external system and operates directly with raw tables.
For clear understanding, providing the documents for your reference.
Difference between live connections and DirectQuery
Connect to semantic models in Power BI - Power BI | Microsoft Learn
To set up a Live Connection,in the home ribbon click on Get Data and choose more option.In the search bar, serach for Analysis Services then selsect either SQL Server Analysis Services (SSAS) or Azure Analysis Services. After connecting to the server, you will be aked with connection modes, Choose Connect live (or Live Connection) to establish a live connection.
Proving the screenshot fot your reference.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you for being a part of Microsoft Fabric Community Forum!
but what is the difference of live connection and direct query, i could not find live connection from power bi desktop, only can see import mode and direct query
Hi pennyhoho117 ,
Thank you for your response.
In Live connection, data is not imported into Power BI, it remains in the external data source and data is pre-modeled like SSAS.Where in DirectQuery, data is also not imported into Power BI, it remains in the underlying relational database like SQL Server and it does not require pre-aggregated data in the external system and operates directly with raw tables.
For clear understanding, providing the documents for your reference.
Difference between live connections and DirectQuery
Connect to semantic models in Power BI - Power BI | Microsoft Learn
To set up a Live Connection,in the home ribbon click on Get Data and choose more option.In the search bar, serach for Analysis Services then selsect either SQL Server Analysis Services (SSAS) or Azure Analysis Services. After connecting to the server, you will be aked with connection modes, Choose Connect live (or Live Connection) to establish a live connection.
Proving the screenshot fot your reference.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you for being a part of Microsoft Fabric Community Forum!