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.
Thank you Mehta, that was the issue.
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.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156