Forum Discussion
ODBC MONGO TROUBLES ON SQL QUERY
Hello! im trying to connect pbi with mi db on mongo atlas i have set up bi connector and the odbc in mi local pc I can see the tables when i get the data , but the problems come when i do the conne...
Hello,
in my case ` (backticks) helped. I needed to wrap it like `nestedTableName.field` with backticks.
In my case BetconstructTrans is a base table and jsonBetConstAddInfo is an array with nested docments