Unable to select array items from a Mongodb collec...

FabCon is coming to Atlanta

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Fabric Community

- Submit ideas & vote
- Fabric roadmap
- Community support
- Product support

Register
·
Sign in
·
Help

Go To

Power BI forums
Get Help with Power BI
Desktop
Service
Report Server
Power Query
Mobile Apps
Developer
DAX Commands and Tips
Custom Visuals Development Discussion
Health and Life Sciences
Power BI Spanish forums
Translated Spanish Desktop
Training and Consulting
Instructor Led Training
Dashboard in a Day for Women, by Women
Galleries
Data Stories Gallery
Themes Gallery
Contests Gallery
Quick Measures Gallery
Notebook Gallery
Translytical Task Flow Gallery
TMDL Gallery
R Script Showcase
Webinars and Video Gallery
Ideas
Custom Visuals Ideas (read-only)
Issues
Issues
Events
Upcoming Events

cancel

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Search instead for

Did you mean:

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Power BI forums
Get Help with Power BI
Custom Visuals Development Discussion
Unable to select array items from a Mongodb collec...

Topic Options

Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Printer Friendly Page

All forum topics
Previous Topic
Next Topic

Anonymous

Not applicable

Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Email to a Friend
Report Inappropriate Content

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

‎06-09-2022 06:28 AM

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.