Forum Discussion
Incremental refresh and real-time data
Hey Anonymous,
Possible steps to fix the Incremental Refresh + Real-time DirectQuery issue:
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.
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.
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).
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.
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
I would go to power query and refresh the preview and try again.
If the above does not solve, please check this: the minor changes you indicate might include the cancellation of a date/time column, needed for the Incremental Refresh? Or of the parameters for the incremental refresh (RangeStart etc)?
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