Forum Discussion

JHob's avatar
JHob
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Gateway connection to Mongo DB

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 connec...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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's avatar
JHob
Icon for Advocate I rankAdvocate I
6 years ago

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's avatar
mikedoyle
Regular Visitor
2 years ago

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 })