I hope you are doing well. I am experiencing a similar situation to yours.
However, I already changed the data type from the field "Adobe ID" which made me lose all the information regarding this field.
After realizing what we had done, we were able to generate a file with historica...
We have a field "Adobe ID", which is the identification key of the "Profile" table and which used to be an integer, mandatory and unique field (one adobe ID per client).
Once we changed the type from integer to TXT, due to external reasons, all of the clients lost the Adobe ID information.