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, want to select the array elements in my power query. Please let me know if I missed anything. 

 

Below are the errors I am getting:

 

Please help!

 

No Replies