DataSource.Error: ODBC: ERROR [42S22] [MySQL][ODBC 1.4(a) Driver][mysqld-5.7.12 mongosqld v2.14.4]Un

[puneethsb123]

We are running a query in power bi through ODBC DSN connection of Mongo DB BI connector  Is there a solution to the following error 

DataSource.Error: ODBC: ERROR [42S22] [MySQL][ODBC 1.4(a) Driver][mysqld-5.7.12 mongosqld v2.14.4]Unknown column 'TOPGUID_NAME' in 'field list'
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=UAT-ANSI
OdbcErrors=[Table]

Query used 

SELECT ColumnA,Column B
FROM collection

when we run select column A from collection working but after adding 2nd coloumn not working.

Tried both Ansi and Unicode in DSN setting

[v-chuncz-msft]

@puneethsb123 

This seems to be more related to the ODBC Driver. You may check the identifier quote character.

[puneethsb123]

ODBC Driver 64 bit and setup is perfect
Tried with both Ansi and Unicode
Check source data no issue with it
When we run query from Power bi to Atlas BI connector 

Select column A from tableA getting result

Select columnA,columnB from table A giving an error Unknown column

DataSource.Error: ODBC: ERROR [42S22] [MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.4]Unknown column 'columnB' in 'field list'
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=APROD-U
OdbcErrors=[Table]

[Ram123]

after changing the refresh time to 30 seconds in Mongo Atlas from Mongo side issue might get resolved. You can check