Forum Discussion

adrianVE278's avatar
adrianVE278
Frequent Visitor
3 years ago

SQL Atlas Intergace (mongoDB) connecting Power BI

OS: Windows 11 Pro

PBI: Version: 2.117.984.0 64-bit (May 2023)

ODBC SQL Atlas Interface: V.0.1.4

Power Bi Connector: V.0.1.4

 

Currently I have configured the SQL atlas Interface beta connector, I read and connect data from a federated database, in all the collections of the database, the load from PBI works fine, however I have 2 collections that give me this error,

 

No se han podido guardar las modificaciones en el servidor. Error devuelto: 'OLE DB or ODBC error: [Expression.Error] Data source error occurred. SQLSTATE: HY000 NativeError: 96 Error message: ODBC: ERROR [HY000] [MongoDB][Core] Trying to execute query failed with error: Kind: Command failed: Error code 96 (OperationFailed): failed getting result set schema: translator error: project fields may not be empty, contain dots, or start with dollars, correlationID = 176a2801865a657aba0d5641, labels: {}. '.

 

I don't know if it has something to do with the flexibility of the collection, for example, some documents have a string that comes with integers, and other documents this array does not exist... Does that influence the load? I was also unable to load this collection using the Mongo BI connector.

 

The collection:

 

 

ideas????

No RepliesBe the first to reply