Accessing and filtering array objects in Excel/PowerBI using BI Connector


We have a document with arrays within it. We want to access and filter the array fields . As they are arrays `` doesnt work on them. What is the best way to access them?

Please note: We are using BI Connector to access MongoDb Enterprise. (on-prem)