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 what the problem make this fault.Therefore, it's array make the data list shut.Is any one encounter this situation? R CODE library(mongolite) m <- mongo("customer",url="myurl") customer <- m$find()with my screenshot.The blue word are in R and other one is in power bi.

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!

MongoDB With r | Microsoft Fabric Community

Forum Discussion

Related content

Connection MongoDB

Trying to connect to MongoDB using MongoDB ODBC driver

Downloading MongoDB Driver

MOngodb to Powerbi Integration

MongoDB CDC - org.apache.kafka.connect.errors.DataException: Invalid value: null used