Forum Discussion

bdherh's avatar
bdherh
Icon for Helper I rankHelper I
6 months ago
Solved

Refresh Direct Query not refreshing

I have a dataset that I changes regularly thoughout the day.  I originally created a report using Import data and set the frequency every 30 minutes, which in this case is not ideal but adequate.  I ...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    6 months ago

    Hi bdherh,

    Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to FBergamaschi & Natarajan_M for sharing valuable insights.

     

    DirectQuery models do not use scheduled refresh. Instead, they retrieve data from the source each time a visual is queried. However, in the Power BI Service, query results can be cached, meaning visuals may not automatically reflect the latest data unless the report page is refreshed or Automatic Page Refresh is enabled.

    As per Microsoft documentation, in DirectQuery scenarios the data is not imported, so scheduled refresh does not apply to data updates and is only relevant for limited cases such as metadata updates.

    Possible solutions:

    • Refresh the report page manually
    • Use Automatic Page Refresh (APR) for near real-time updates
    • Ensure all tables are using DirectQuery mode
    • Confirm no tables are set to Import (composite models can behave differently)

    For more details, please refer to official Microsoft Doc: Configure scheduled refresh – Power BI

    Best regards,
    Ganesh Singamshetty

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
6 months ago

Hi bdherh 

whether you use Import or DirectQuery, it seems your capacity is not enough for the data size

 

Either you shrink the data size (eliminating useless columns for example ar aggregating the data) or you increase the capacity. I do not see other options. 

 

Desktop uses the memory of the machine you use it run, in cloud you use the resources corrsponding to your capacity

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

  • bdherh's avatar
    bdherh
    Icon for Helper I rankHelper I
    6 months ago

    I put a manual refresh button on the reports to give the users the ability to refresh the data if it has not already been reset.  Not sure why I had to do this if it is a Direct data access, but I did and it is working for them

    • Irwan's avatar
      Irwan
      Icon for Super User rankSuper User
      6 months ago

      hello bdherh 

       

      if pbi desktop and manual refresh button worked then it might not direct query row limit issue.

       

      what error does it show in refresh report?

      some sources need a connection or gateway to make schedule refresh works.

       

      Thank you.