Power BI Connector for MongoDB

Build 24.0.9062

DataModel

By default, the provider will not automatically discover the metadata for a child table as its own distinct table. To enable this functionality, set DataModel to Relational .

Possible Values

DOCUMENT, RELATIONAL

データ型

string

デフォルト値

"DOCUMENT"

解説

When setting DataModel to Relational, the discovery of child tables extends to root level elements and those found within top-level array elements. Additionally, the provider exposes _id and parent_id columns to enable JOIN operations between parent and child tables. The _id column acts as a primary key for the flattened table, while the parent_id column identifies the parent document.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062