Specifies the name of the primary key column that holds the row number.

Syntax

Connect-ExcelOnline -PrimaryKeyIdentifier string

Data Type

cstr

Default Value

"Id"

Remarks

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.

If no value is supplied for PrimaryKeyIdentifier, the CData Cmdlets PowerShell Module for Microsoft Excel Online uses the default value of Id for the primary key.