Hi Team,
I have existing organizational units and facilities in my MSM environment which I uploaded via the Excel Template function. Now, I would like to create upgrade my game and create a Power Query connection to upload the organizational data directly from a master data source list as this list contains more and better information.
I created the connection, used the same organizational unit name as already existing in MSM and thought that the system would recognize the already existing org unit and just enhance the data. But instead, the upload did not work with the error message "Duplicate record". So the system did indeed recognize the existing org unit, but did not add to the data or overwrite it.
How can I create a power query connection for the organizational units if the data was already uploaded via Excel template? Or can you think of another way to achieve what I'm trying to do?
Thanks and cheers,
Lea
