Forum Discussion
MongoDB ODBC connector for PowerBI - Incremental refreshes are slow
Hi all, We are using the Mongo DB ODBC connector for PowerBI to connect the MongoDB data source. We have implemented incremental refresh as per our data size is concerned. But after the initial refr...
lbendlin: I just found something in the Microsoft docs. It says, only the PostgreSQL connector supports query folding. No other connectors support query folding if you use a native database query.
I am unsure about this.
Here is the link (https://docs.microsoft.com/en-us/power-query/native-database-query)
- lbendlin
Super User
Note that query folding is not a hard requirement for incremental refresh. It is merely a preferred option. Incremental refresh will work with a source that doesn't fold.
