Some columns are missing, when connected Power BI to MongoDB

[HemanthV]

Hello Everyone,

I have connected to MongoDB with cdata Connector, when i try to pull the data, some columns are missing. Please see the below image

  

Some documents have additional columns as shown above, those columns are missing when i pulled data to power bi

As you can see "is_repeat_customer" column is not showing in power bi. I am facing this issue with multiple tables, lot of columns are missing. Please provide a solution for this problem.
Thanks in advance..!!

@Greg_Deckler @amitchandak

[amitchandak]

@HemanthV , custom connector, you might have to contact developer

[HemanthV]

@amitchandak Thank you so much for your reply, so the problem is with connector itself? will you suggest any good connectors for mongodb which may not have this issue.

Thanks in advance..!!

[amitchandak]

@HemanthV , there is another option to connect using odbc driver, see if that can help

https://docs.mongodb.com/bi-connector/current/connect/powerbi/

[sharath123]

@amitchandak  Even if we connect through ODBC also, it is not returning all the columns.
 some columns are missing.
please suggest any other solution to fetch all the data/all the columns