Incremental update with Power BI Service

Vincent_Quillet · 2024-01-17T10:21:58.274Z

Hi
I have successfully installed MongoDB Atlas Connector and ODBC Driver on a On-premisePower BI Gateway to collect data from Atlas.
Now I would like to have incremental refresh.
Is it possible with Atlas Connector ?
Any recommandation ?
Thanks a lot.
Regards
Vincent

Alexi_Antonino · 2024-01-17T14:38:51.332Z

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.

Vincent_Quillet · 2024-01-18T09:45:13.667Z

Hi @Alexi_Antonino - Thank you for your reply.
From my understanding, Direct Query (and Premium plan) are not mandatory
see Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn :

Incremental refresh is supported for Power BI Premium, Premium per user, Power BI Pro, and Power BI Embedded models.

I don’t want to have real time data at this point and it seems that PBI Pro is satisfying for now.
So AFAIU the most important is to know if Atlas MongoDB connector is able to do Query folding.
I will continue investigating and am waiting for your feedback.
Thanks
Regards

Alexi_Antonino · 2024-01-18T14:01:10.487Z

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 · 2025-01-27T09:50:29.575Z

Which version is this?

Alexi_Antonino · 2025-04-12T02:53:30.271Z

@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.