Unanswered

Dataverse tabel overwritten

(0) Share

Report

Posted on by Yvonzim

242

I'm a bit panicking, during an excel import with new data in Dataverse table, it seems all existing rows are there but all columns are completely empty but the relation with other tables still exist!

The old export file is overwritten with no versioning (murphy's law)

Is there a way i can restore the table?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

SteRe 254 on at

Like (0)

Report

Is your Audit History active so you can see the changes?
To restore, it might be best to check Admin Center for available backups to your environment. You might be able to restore into a new environment and get the old version from there. Just ensure to pick the latest time before data import.

Was this reply helpful? Yes No
Yvonzim 242 on at

Like (0)

Report

Im affraid it is turned off

Was this reply helpful? Yes No
SteRe 254 on at

Like (0)

Report

Looks like. Just to be sure check any record in the affected table -> related -> audit history

But as it looks like it is turned off you will need to check for backups.
You can also raise a service ticket with MS but most likely they will run backup restore too.
Restoring a backup is always into a different environment. So your affected system won't be overwritten.

Was this reply helpful? Yes No
Yvonzim 242 on at

Like (0)

Report

Thanks for the quick response.
I'm now trying to restore a backup, if that does not work I will contact MS.
Keep you (all) posted 🙂

Was this reply helpful? Yes No
Verified answer

Yvonzim 242 on at

Like (1)

Report

The backup was a solution.
I created a backup in a new Sandbox environment via powerapps admin portal.
From there I could do a export to excel and import in the production environment.

Was this reply helpful? Yes No