Table.PartitionValues

Table.PartitionValues is a Power Query M function that retrieves information about how a table is partitioned. The function returns a table where each column is a partition column and each row corresponds to a partition in the original table.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Table.PartitionValues( table as table ) as table

Description

Returns information about how a table is partitioned. A table is returned where each column is a partition column in the original table, and each row corresponds to a partition in the original table.

Related functions

Other functions related to Table.PartitionValues are:

• Table.Partition
• Table.Split
• Table.SplitAt
• Table.ToColumns
• Table.ToList
• Table.ToRecords
• Table.ToRows
• Table.Transpose

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-partitionvalues
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.