Power BI Connector for Elasticsearch

Build 24.0.9060

FlattenObjects

Set FlattenObjects to true to flatten object properties into columns of their own. Otherwise, objects nested in arrays are returned as strings of JSON.

Data Type

bool

Default Value

true

Remarks

Set FlattenObjects to true to flatten object properties into columns of their own. Otherwise, objects nested in arrays are returned as strings of JSON. The property name is concatenated onto the object name with a period to generate the column name.

For example, you can flatten the nested objects below at connection time:

"manager": {
  "name": "Alice White",
  "age": 30
}
When FlattenObjects is set to true, the preceding object is flattened into the following table:

Column NameColumn Value
manager.nameAlice White
manager.age30

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