Forum Discussion
🆘 Issue with Enabling Incremental Refresh in Power BI (DirectQuery Mode from SQL Server)
Hi Sreethar_14,
Thank you for reaching out to the Microsoft Fabric Forum Community.
incremental refresh is not supported in DirectQuery mode for SQL Server. To use it, you must switch to Import mode or configure a hybrid model using Power BI Premium.
If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & Regards,
Prasanna kumar
Hi Sreethar_14
You need to change your mode from DirectQuery to Import mode. Add the filter for the date ranges then close and apply. For the default date ranges, I usually keep it to the same day then when setting up your incremental refresh policy, that's where I change it to specific month.
Then, on the optional settings you can enable the refresh with realtime in DirectQuery, but be wary as this can only work on Premium workspaces.
If you're already using DirectQuery from the beginning, I don't see a need to use incremental refresh. However.... what I think you're probably looking for is called Dynamic M Query. You can find more information on it here:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters