KNOWLEDGE BASE

Data missing when connecting to MongoDB BI Connector


Published: 05 Dec 2017
Last Modified Date: 06 Dec 2017

Issue

When connecting to the MongoDB BI Connector, data may not appear as expected. When an extract is created, fewer records are returned. 

Environment

  • Tableau Desktop 10.4.0
  • MongoDB BI Connector

Resolution

Work with Mongo to ensure your Bi-Connector and .DRDL file is configured properly and the data is mapped per your data requirements. 

Cause

Incorrect data type mapping in the .drdl file needed to configure the BI connector.
 

Additional Information

Per MongoDB Product help:

The schema generation tool mongodrdl outputs a schema file in Document Relational Definition Language (DRDL) format, but you should verify that the schema it proposes matches your data requirements. Examine both the table structure and field types to ensure that you can generate your intended reports.
Did this article resolve the issue?