Incremental refresh with Import Mode

Hi Anonymous,

Yes, incremental refresh works with the Import data mode in Power BI. In fact, incremental refresh is designed specifically for scenarios where large datasets are imported, allowing only changes (new or updated data) to be loaded during refreshes, instead of reloading the entire dataset.

We are using Incremental Refresh in our organization for reports which have large volumes of data/ transactions flowing in everyday. The datasets are configured to use import mode and connect with our SQL Data Warehouse.

Use the following link to refer to configuring incremental refresh in Power BI - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure 

As for the Native Query option being greyed out, it happens in cases where steps in Power Query are not folding back to the source (query folding). Query folding is necessary for incremental refresh to work efficiently, as it allows Power BI to push query steps directly to the source database.

Do let me know if you need further help in configuring incremental refresh for your tables. Happy to help!🙂