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,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the query.
Since data in DirectQuery mode is always queried directly from the data source in real time, there is no need for scheduled refresh.
Providing you with the documents which might help you.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
As my report is published to Power BI Service with Direct Query Mode, we need to send the report to users using Power Automate, hence we want to set up Refresh Schedule to refresh latest report data, when report with Direct Query Mode, cannot set refresh schedule?<we dont use Import mode because import mode would save report data to power bi cloud, but out company not allow it as there is sensitive data>
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
