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

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

Hi bdherh ,

I understand your scenario correctly: you changed the import mode to direct query mode, but you're not seeing the latest data in the report. Could you please provide details on the following questions?

  1. Do you have all the tables in the semantic model set to direct query, or just the fact table? If possible, please share the data model.
  2. If all your tables are in import mode except for the fact table, your fact table will be queried directly against the database. However, the other imported tables will still need to be refreshed at regular intervals
  3. If all your tables are in direct query mode, this setup should always retrieve the latest data from the source, and you do not need to refresh the model.
  4. Can you pull a measure from the direct query table and create a sample visual using a date or any dimension? Check if the direct query table is working correctly. If you are not getting the desired results, please review your Power Query steps.

Thanks 
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster