Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
adrianVE278
Frequent Visitor

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: {}. '.

adrianVE278_0-1687207000362.png

 

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:

adrianVE278_1-1687207022302.png

 

adrianVE278_2-1687207028832.png

 

ideas????

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors