MongoDB connector for direct queries

[jagadeesh_k]

We are using PowerBI for our reporting requirements, the data source is MongoDB. We are leveraging Azure CosmosDB Connector to model the data; however, this seems to be slow and inefficient with the data volume.

As CosmosDB connector doesn’t support querying for MongoDB API, we are exploring other options for direct queries so that we can filter/aggregate the data before we import large data set.

One option we were trying is using R script as data source, using mongolite to filter and query the dataset and transform the data and load into the powerBI. This is working as expected in the powerBI desktop while from powerBI service, we are not able to connect to the data source.

Extension{"extensionDataSourceKind":"R","extensionDataSourcePath":"R"}

Any assistance on this will be a great help.

Also, would like to know if there is similar use case for reference; modeling mongoDB for powerBI using out of box connectors or custom connectors.

[v-deddai1-msft]

Hi @jagadeesh_k ,

Did you want to direct query to mongodb from power bi? You can try to use odbc connector and try to direct query to odbc data source: https://github.com/sgoley/DirectQuery-for-ODBC-in-PowerBI

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai