PowerBI with MongoDB Atlass

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.