Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RGouda
Frequent Visitor

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. 

RGouda_0-1654780989146.png

RGouda_1-1654781009076.png

 

Below are the errors I am getting:

RGouda_2-1654781038389.png

 

RGouda_3-1654781048013.png

Please help!

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors