Set this property to control the name of the primary key.

Syntax

Connect-ExcelOnline -PrimaryKeyIdentifier string

Data Type

cstr

Default Value

"Id"

Remarks

Determines the name of the primary key column which holds the row number. The default value of the primary key is Id.

Set this property if there is a column named Id in the table you are querying, or if you prefer to change the name of the primary key.