Forum Discussion

dorieldoriel's avatar
dorieldoriel
Frequent Visitor
2 years ago
Solved

Automatic refresh/scheduled refresh

Hi, friends. I am struggling with the refresh functionality. I use Power BI desktop, which loads data from the SQL. I cannot create "Direct query" (probably because of LEFT JOIN or some other comman...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dorieldoriel 

 

In Power BI Desktop, there is no scheduled refresh feature like in Power BI Services. However, automatic page refreshes for reports can be achieved using the DirectQuery connection.

 

To set up automatic page refresh in Power BI Desktop, make sure you use a DirectQuery connection to the SQL database. Please try the following steps:

 

Connection to databases (direct query or live connection)

 

 

Find the Page Refresh section at the bottom of the pane.

 

 

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

 

To set up a scheduled refresh, you need to publish the report to the Power BI service.

 

Once published, you can configure a scheduled refresh for the dataset. If the SQL database is local, this involves setting up a gateway.

 

Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

 

Also the workspace you mentioned was created on power bi service.

 

Create a workspace in Power BI - Power BI | Microsoft Learn

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dorieldoriel's avatar
dorieldoriel
Frequent Visitor
2 years ago

Thank you very much. But why is my SQL query not accepted as a DirectQuery? I dont know what is allowed to be the "DirectQuery". Its only SELECT and JOIN, or how basic my query must be to be a DirectQuery?

    • dorieldoriel's avatar
      dorieldoriel
      Frequent Visitor
      2 years ago

      Thank you, this is what I was looking for. Excuse my amateurism 😄 still learning.

       

      Thank you for your swift responses, I really appreciate.