Jarod Barnhart on 16 May 2023 18:49:49
Currently, the MongoDB odbc connector is very slow, and I'm sure that building a custom connector is time consuming. By allowing support for the R mongolite package we can customize our queries to our MongoDB servers. This allows us more flexibility than the odbc connector (which just pulls an entire collection), and can let us filter to just the data we need, reducing storage space. It can also be used in conjunction with the on-premises data gateway to update data automatically.
Mongolite has 3 other packages which it imports, jsonlite, openssl, and mime, all of which are already supported by PowerBI service.