Forum Discussion

Bnemoh's avatar
Bnemoh
Regular Visitor
3 years ago

MongoDB Atlas SQL

I have been trying to connect to MongoDB to query clusters, I did create an atlas connection and selected the PowerBI Connector driver for me to query the database and get data into a dataflow servic...
dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for the help. Now i have connected my powerBI to MongoDB atlas.

Irah24's avatar
Irah24
Frequent Visitor
1 year ago

Hi @ Anonymous,

am having few problems while connecting with MongoDB Atlas SQL if i connect through Import and Transform the JSON file in power query mode than the power bi is taking very long time to Refresh as i have used pivot , groupby how to resolve this ,

and if i connect via Direct Query it is fast but am able to FLATTEN and UNWIND the few columns like k and v array of objects , but unable to to extract Array of object specific column am getting error as 1007 column not found i tried many ways but not getting correct solution , can you please guide me which method is good and direct query am using SQL Native Query option for writting SQL Query itz working but while extracting specific columns in array of objects am getting error 1007 column not find it is stored as array and objects