Incremental update with Power BI Service

Hi @Vincent_Quillet - I am not sure if our connector works with this feature. I will try to test it out myself, and ask MS if they can tell us directly if it should work in theory. I came across a few articles that were focused on incremental refresh plus real time data. For that, it requires a Direct Query connection type. And we are planning to release a new version of our connector that include DQ support. Also, I saw that incremental refresh requires a premium power bi license. I will research this some more and report back.

Hi There - yes we have a version of the connector that can handle query folding, but it is not the version MS is shipping currently (we are waiting for them to update to this version now). If you want the version that supports native sql and query folding, please download the latest from our MongoDB Download Center: Download Power BI Connector | MongoDB
Don’t forget to download both the connector and driver (odbc) as both have code to support the native sql and query folding.

Best,
Alexi

@Pietro_Desiato the version we distribute on our MongoDB Download Center and the version distributed by Power BI are the same at this point in time. They only get out of sync if we release a new version and there is a lag with Microsoft releasing it. The lag only last about month at the most though. I hope this helps.