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,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your input rohit_singh, I have tried as you suggested but it did not work.

 

I have tried different syntaxes for the highlighted queried column, but the result is same popping up with errors as mentioned in my post.

  1. `worlimatka_result_playerCards.0.card.rank`
  2. [worlimatka_result_playerCards.0.card.rank]
  3. `worlimatka_result_playerCards[0.card.rank]
  4. `worlimatka_result_playerCards[0].card.rank`
  5. `worlimatka_result_playerCards.[0].[card].[rank]`

rohit_singh's avatar
rohit_singh
Solution Sage
4 years ago

Hi Anonymous ,

Sorry to hear that didn't work out for you. I'mvnot really sure why this might be happening. I was reading through the official Mongodb documentation for the BI connector and maybe this could help 
https://www.mongodb.com/docs/bi-connector/current/components/

You seem to be using the MySQL driver which is not listed for use with PowerBI. Maybe it is worthwhile trying a different driver for ODBC connection with PowerBI?

Kind regards,

Rohit