Direct Query/Import Mode/Live Connection questions

[pennyhoho117]

if i use directQuery mode, can set Refresh schedule? as i know, Power BI Report Server does not support refresh schedule for directQuery mode, so Power BI service support refresh schedule when report with DirectQuery Mode?

Meanwhile, where can find the source source which support/not support import mode/direct query/live connection and refresh schedule??

[Anonymous]

Hi @pennyhoho117 ,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and select "Yes" if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @pennyhoho117 ,

Hope that your query has been resolved. If our community member's response addressed your question,

If it helps, please give us Kudos and consider Accept it as a solution and click YES to help the other members find it more quickly.

Thank you for being a part of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @pennyhoho117 ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by me. Please let me know if it was helpful. If yes, please Accept the answer and give Kudos that it will be helpful to others to find it quickly.
Thank you for being a part of Microsoft Fabric Community Forum!

[Anonymous]

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.

[pennyhoho117]

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>

[Anonymous]

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!

[pennyhoho117]

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

[Anonymous · Accepted solution]

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!