Gateway connection to Mongo DB

[JHob]

I have setup a Gateway connection to a Mongo DB datasource in the Power BI service.

Do I need to enter the connection credentials in my Desktop Power BI report as well or is it possible to connect to the gateway and get access to the Mongo DB datasource?

[v-lionel-msft]

Hi @JHob ,

You can use the ODBC connector to connect to the Mongo DB data source in Power BI Desktop.

Connect from Microsoft Power BI Desktop 

Best regards,
Lionel Chen

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

[JHob]

Thank you Lionel

I have succesfully managed to used the ODBC connector in desktop.  I now want to setup a Power BI dataflow to the MongoDB datasource.  Do I use the ODBC connector in the Power BI service?

Kind regards

[v-lionel-msft · Accepted solution]

Hi @JHob ,

"I now want to setup a Power BI dataflow to the MongoDB datasource.  Do I use the ODBC connector in the Power BI service?"

Yes, in addition, there is an article here that you may read.

Create MongoDB Dataflows on PowerBI.com 

Best regards,
Lionel Chen

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

[JHob]

Many thanks, I now have this working.

I am having one further issue though.  One of the fields within an object is not populated and the column is missing when I connect in the dataflow.  There are only 9 records that have a true value in this column, the rest (several 1000) are null. 

Why would this column be missing?  How can I make sure that all items in an object are reflected?

[mikedoyle]

You need to generate the schema in Mongo so that PowerBI can see the missing field....Example:

AtlasDataFederation admin> db.runCommand({ sqlGenerateSchema: 1, sampleNamespaces: ['namespace.collection'], sampleSize: 20000, setSchemas: true })