I don't receive all fields in Power BI from MongoDB Atlas using ODBC

The problem here is probably the sampling size system variable on the BI Connector:

If you are using MongoDB Atlas, this can be configured within the Atlas admin web interface in an optional configuration text box when you first set up your BI Connector. It’s set my default to 100 but you can change this to 0 to force the connector to sample all the objects in a collection.

5 Likes