Does PostgreSQL connector on PowerBI support incremental load?

[Robbief]

I've had issues with Odata and incremental load, so looking at alternatives to get this working now.  

As the Postgresql now has a connector which supports native query folding:

https://docs.microsoft.com/en-us/power-query/connectors/postgresql

Will this also work with incremental load?  Does anyone have any experience with this? Anything to be aware of, or any recomended alternatives?

Appreciate your feedback.

[v-cazheng-msft]

Hi, @Robbief 

You can refer Query folding and Query folding guidance in Power BI Desktop which explain Query folding and incremental refresh in Desktop.

Best Regards,

Caiyun Zheng

[ibarrau · Accepted solution]

Hi. The phrase would say "if you data source support query folding, it might have incremental refresh". You can test it right clicking on the first step of Transform Data (power query) menu and look at "Native Query" option. If it's not grey out it might work with incremental.

I think I have seen a post sometime ago that said he has configured incremental with citus, that is like a postgres.

Hope this make sense.