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...
Hi Anonymous ,
I saw your column name is "order_items.item.id" in your image, so you could try to use this in your query to see whether it work or not(you also need to make sure your table name is correct). By the way, I am not sure whether this is caused by the "." in column name, if above column name can't work, you ciould try to rename column as "order_items_item_id", then use this in query to check it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.