PowerBI with MongoDB Atlass

[kjellhaaland]

Hi!

Im having an issue when importing data from MongoDB Atlas through the MongoDB ODBC driver. Most of the data are modelled fine in PowerBI, but there are some columns missing. It seems to be issues with certain "optional" fields in my MongoDB dataset that is modelled as arrays.

Does PowerBI analyze all documents/rows when creating a datamodel from ODBC? Or does it only scan a certain amount of the documents to create the model?

{
id: "ID",
name: "Anakin",
children: [
  {
    name: "Luke",
    height: 54
  }
], // This array is present at all documents, and gets modeled fine in PowerBI
weapons: [
  {
    type: "Lightsaber"
    damage: 1000
  }
] // This array is only present in some documents, and does not appear in PowerBI
}

I am using the ODBC connector provided by MongoDB Atlas. 

[v-lili6-msft]

hi @kjellhaaland 

To my knowledge, PowerBI will analyze all documents/rows when creating a datamodel from ODBC, there should be something wrong in your side, I would suggest you to create a support ticket to get further help.

Regards,

Lin