Question 198992 in Mongodb Question posted in
The official documentation can be found here.

Mongodb – Missing column on power bi

I exported a collection in mongo db as a csv file and then imported that csv into power bi…all fields imported except one . Even after manually adding it in mongodb before exporting as csv, the column showed blank when I loaded it into power query. The Column shows channels used such as mobile app, website etc…What can be the issue and how can I fix it.

I tried manually adding the column and it showed blank on power bi.

Tags:

2

Answers


  1. 0

    Look at code for part that says

    ,columns =16,

    and remove that

    Login or Signup to reply.
  2. 0

    As column # in all csv should be same . While using folder connector to keep all dataset into model power query take first csv file and based of it analyze schema and column# .If let suppose any csv have more column with it will not show there . So you need two checklist

    1. Check all csv have similar schema with same number of column
    2. Second check the parameter of columns

    I hope this will help you

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search