Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Unable to select array items from a Mongodb collection through ODBC BI connector in Power Query.

Hi, everyone. I am facing issues in PowerQuery while selecting/querying array items from the https://studio3t.com/knowledge-base/articles/sql-query/#querying-arrays link.  I have a collection below,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks rohit_singh for your quick response. I am using MongoDB ODBC driver as listed below. 

 

rohit_singh's avatar
rohit_singh
Solution Sage
4 years ago

Thanks for confirming Anonymous . In that case I would suggest a workaround by loading the table without writing an SQL statement, which means loading all columns into Power Query. You can then expand the nested columns you need manually and use them, and remove any other columns you don't need.

Kind regards,

Rohit

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂