Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Incremental refresh and real-time data

Hello! I’m testing a case where Incremental Refresh and real-time data (DirectQuery) could be a good fit. I’m building a dataset with all fact tables using the Incremental Refresh + real-time data f...
Need Help
  • jaineshp's avatar
    jaineshp
    1 year ago

    Hey Anonymous,

    Possible steps to fix the Incremental Refresh + Real-time DirectQuery issue:

    1. Check date/time filters – Make sure your fact tables still have a proper date/time column with continuous values and that the filter logic matches the incremental refresh range parameters.

    2. Re-enable policy – If Power BI detects a schema change (even small), it can invalidate the policy. Remove the existing policy, re-set it from scratch, and re-publish.

    3. Validate DirectQuery toggle – The Get real-time data option will be grayed out if:

      • The table is missing a supported date column, or

      • The model storage mode isn’t set to Import + DirectQuery (Hybrid).

    4. Rebuild partitions – In some cases, you need to delete and recreate the table in Power Query, then re-apply the incremental refresh with real-time enabled before publishing.

    5. Service vs Desktop behavior – Test publishing a clean PBIX with only one fact table and the correct policy to the Service. Sometimes Desktop shows the warning, but the Service applies it correctly.

     

    Fixed? ✓ Mark it • Share it • Help others!


    Best Regards,
    Jainesh Poojara | Power BI Developer

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi Anonymous 

 

Could you please try below steps:

 

  • Keep RangeStart and RangeEnd (Date/Time) and unchanged names.

  • In each fact table, filter as [DateTime] >= RangeStart and [DateTime] < RangeEnd, with folding intact.

  • If View native query is disabled, remove or move steps that break folding like merges, custom functions, index columns.

  • Reapply Incremental refresh, save, refresh.

  • Get real time data only lights up for Premium or PPU and sources that support DirectQuery.