Some columns are missing, when connected Power BI to MongoDB

Question

Hello Everyone,&nbsp;I have connected to MongoDB with cdata Connector, when i try to pull the data, some columns are missing. Please see the below image&nbsp;&nbsp;&nbsp;Some documents have additional columns as shown above, those columns are missing when i pulled data to power biAs 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..!!&nbsp;Greg_Deckler&nbsp;amitchandak

amitchandak · Answer

HemanthV , custom connector, you might have to contact developer

hemanthv · Answer

amitchandak&nbsp;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.&nbsp;Thanks in advance..!!

amitchandak · Answer

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 · Answer

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

anonymous · Answer

hey, I was facing the exact same issue wanted to check if you have solved your problem

Forum Discussion

Some columns are missing, when connected Power BI to MongoDB

5 Replies

Related content

Missing Connection Details

Inferring Missing Columns and Imputing Missing Data

Missing columns (API connection from Kobo)

Missing Connection Details - Dataverse

connecting to semantic model missing columns