Automatic table detection from JSON files

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Sep 20, 2020 -

Feature details

When using the JSON connector, this new feature will automatically flatten the JSON into a table. Previously, users had to flatten records and lists manually. This new feature also adds support for JSON lines (or newline delimited JSON where each line in the file is a JSON string).

See also

Power Query JSON connector (docs)