Forum Discussion
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,...
rohit_singh, your approach to load all columns and expand nested columns is taking a lot of time to load. That's the reason, I have chosen to select/query the required columns I use in the report. I want to restrict unnecessary columns in my dataset.
I am not only facing this issue for this collection but there are multiple collections as such. Considering my huge data size, I opted for this method of selecting/querying the required columns.