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!
Hi pennyhoho117 ,
With DirectQuery, you do not need to "refresh" the report. Users will always see the latest data when they open the report. Instead, you can automate notifications to ensure they know when to access the report.
Glad that your query got resolved.If yes, please give us Kudos and consider accepting it as solution.For any further assistance, feel free to reachout.
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!