Forum Discussion

RachC's avatar
RachC
Helper I
9 years ago
Solved

MongoDB With r

hello everybody , I connect mongodb with mongolite instead of ODBC(Because of cost). but I got some trouble when I search in R.The data is displayed well but not work in power bi. I try to find the...
Need Help
  • RachC's avatar
    RachC
    9 years ago

    I resolve my problem but itsn't work for all list.

    If you had second or third nest it didn't work. I set a loop to search which column is list() and do unlist() then the error is gone!

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

RachC,

 

You can split this column to multiple rows in Power query. Please refer to the steps below.

  1. Add a custom column.
  2. column expression
    =Text.Split([belongs],",")
  3. Expand to new rows
  4. Results

Regards,

Charlie Liao

RachC's avatar
RachC
Helper I
9 years ago

umm.. it works cool!

 

but it's specify for known column but not for all list.

And need to covert evely column from list to text (or character) .I thought itsn't great for perfomence.I plan to implement transfer function that type of list is made new Table.

 

thanks for your tutorial! 

  • RachC's avatar
    RachC
    Helper I
    9 years ago

    I resolve my problem but itsn't work for all list.

    If you had second or third nest it didn't work. I set a loop to search which column is list() and do unlist() then the error is gone!