Missing Primary Key Field on Unify Option

(0) Share

Report

Posted on by nduati

Hi,

I am trying to unify my entities. However, the primary key field on my entities are missing under the "Please select the primary key". All the other fields are visible apart from my primary key. As per my image below, the TaxPayerID field is missing, yet it's the primary key for my TaxPayers entities. These same thing happens to any other entity on my list of entities. Kindly help.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

smehta 100 on at

Like (1)

Report

RE: Missing Primary Key Field on Unify Option

Hello,

Please make sure your primary key is a string/text field as this is a system requirement. You may have to change the data type of that column to “text” within Power Query.

Was this reply helpful? Yes No
nduati 5 on at

Like (1)

Report

RE: Missing Primary Key Field on Unify Option

Thank you Mehta, that was the issue.

Was this reply helpful? Yes No