Query Errors. Author Sharepoint Name Changed Archived user

[PowerBiNoob37]

Hi,

I have an unusual error in which i cant seem to fix, i have a dashboard that grabs rows from SharePoint, recently it stopped working and i discoverd that one of my users that i recently archived (i removed their licenses and changed their display name to Archived - FirstName LastName). For some reason only half the rows the user created have changed to Archived - FirstName LastName and the others are still pre archived FirstName LastName. So the custom columned i created as a step (column called Employee) that has the Author Columns First Name and Last Name extracted and combined ie Employee = [Author First Name] & " " & [Author Last Name] all the non changed names now show as Error? I cannot figure it out. I do not wish to delete the data and everything i have tried fails?

Also i have tried Changing the name back and then archiving again and the same issue occurs in the same rows? WTF?

Anyhelp?

[whitch]

I've had similar SharePoint issues in the past and been unable to fix them too.  Can you amend your formula which is extracting the names to handle both cases?  Something like:

if Text.Start([your field],8 ) = "Archived" then ... else ...

[PowerBiNoob37]

Nah, cause the error is in the inital grab. I ended up just archiving them all into a new list, the company only needs records for up to 5 years, so they 3 years old and basically useless for them at this stage, keeping the rows would have been preferable, however meh to this problem. I do believe you can go into powershell and change metadata though if your still having issues..