Power Platform Conference| Europe Session

0:00

[MUSIC]

0:09

>> Hey everyone, this is Donia Tarjan,

0:11

Microsoft Solution Engineer of Her With Own.

0:14

>> I'm Alan Garcia, Microsoft MVP,

0:17

and lead evangelist at home.

0:19

>> In today's video, we're going to show you a day in

0:21

a life where you have had a data loss.

0:25

>> Okay. Well, hey, Donia.

0:28

This is, I hope you have a couple of minutes.

0:31

I have been hearing from some of my users that we've

0:35

lost some data and some of our data is looking just right.

0:38

Is there something you can help me with?

0:40

>> Yeah, absolutely. If you have a couple of minutes,

0:42

we can go through it right now.

0:44

>> Really, right now?

0:46

>> Yeah.

0:47

>> That'd be great. Yeah, let's do it.

0:50

>> All right, I'll just a couple of questions.

0:52

Do you happen to know when exactly did you have that data loss?

0:55

It's fine if you can.

0:56

>> Yeah, it was about two, three weeks ago,

0:59

I think is what it was.

1:01

>> Good. Let me actually go ahead and share my screen

1:04

so that we can walk through what happened here.

1:07

>> Okay, that's awesome.

1:10

>> All right. So I am in our org and I can see here in

1:15

the accounts that you have lost some data.

1:17

Was it through accounts or something else?

1:19

>> Yeah, it was accounts and then some of the users said

1:22

there were some contacts as well that just weren't looking right.

1:26

>> Okay, so yeah, I can see here accounts about a month ago,

1:29

we've lost about 50 accounts. That is a big number.

1:33

>> That sounds about the number they were talking about.

1:35

>> Yeah.

1:36

>> Perfect. So actually let me click in here and see exactly what happened.

1:40

Ellen, if I showed you those accounts,

1:43

yes, I can see that 50 have been deleted.

1:45

If I showed you those accounts,

1:46

would you be able to identify if this is the right data?

1:49

>> Not all of them, but there are a few stand out that

1:52

my team has been telling me to be out.

1:54

So if you can show those, is that a big effort for us?

1:57

>> Not at all. I will just click here.

1:59

As you can see, it's Ellen loaded a CSV.

2:02

Let me actually bring this up and show the names for you.

2:05

If these are the right accounts,

2:06

I can go ahead and add them to that.

2:09

All right. So-

2:11

>> Well, that was quick.

2:13

>> Let me see.

2:17

Oh yeah, Disney, Zillow.

2:20

Yeah, definitely. That's definitely the list.

2:23

>> Awesome. I'm more glad that we have identified that.

2:26

So what I'm going to do,

2:27

Ellen, right here is that I'm going to kick off that restore.

2:30

What I want to do before actually moving this data back to our production work

2:35

is,

2:36

I want to see the impact of these deletions.

2:38

If you remember, when we were building this,

2:40

all of our tables are integrated together.

2:42

So I just want to see how this is going to look like and what exactly has been

2:48

affected.

2:49

But you've also-

2:50

>> Yeah, I would imagine it's going to be,

2:52

in fact, maybe that's some of the contact stuff too.

2:55

>> Yeah, yeah, absolutely.

2:57

So let's give it a minute in here.

3:00

You've also mentioned that your contacts looks wrong.

3:04

>> Yeah, yeah. That's what I was saying.

3:05

Some of the contacts, they said just the data,

3:07

the information doesn't look right.

3:09

>> Okay. That actually goes with a preview screen in here.

3:12

I'm assuming it's the same day where all of your contacts,

3:15

and yes, actually nine contacts change.

3:18

This doesn't look right.

3:19

Let's actually start that compare right here and see

3:22

what exactly happened to our tables.

3:25

While this is happening, Ellen,

3:29

going back to our accounts,

3:31

so as you can see in here,

3:32

those 50 accounts affected a lot of other tables.

3:36

There are contacts, opportunities,

3:37

instance, what I can do with my tool is actually I can

3:41

stitch those relationship backs and add them back to our org.

3:44

Is this something that you're looking to?

3:46

>> Yeah, that's amazing.

3:48

I didn't even know all that other stuff was affected.

3:51

So, yeah, if we could get all of it one shot, that would be amazing.

3:55

>> Yeah, absolutely.

3:55

And you don't have to worry about downtime.

3:57

This is not affected.

3:59

It's still going to be up and on for the user.

4:00

It's just going to take a couple of minutes till it starts.

4:03

>> Okay, awesome. That's amazing.

4:06

>> Awesome. I'm going to have here my status bar.

4:08

I would be able to track it.

4:10

So this restoration is happening.

4:12

We just reverted back from that data loss.

4:14

Let's look at our contacts.

4:16

The nine changed contacts.

4:20

Okay, what do you hear? What's going on?

4:24

Let's only see the changed contacts and the changed fields.

4:29

What this is going to give me Alan is it's going to show me

4:32

the previous value and the current value.

4:34

And then we can see what's the good change and what's the bad change.

4:38

So, you can see here that emails have been cleaned up.

4:41

There was some weird numbers.

4:43

But the first name is a look about right.

4:45

These are numbers and it definitely affected the full name.

4:48

>> Yeah, that's what they were saying.

4:50

>> I can go ahead and just restore first and lastly

4:53

and full name to their previous values

4:56

and keep the good change for the email addresses.

4:58

Would that be okay with you?

5:00

>> Yeah, that would be great.

5:01

Is it a huge amount of work to do that?

5:04

>> Well, just a couple of seconds.

5:05

It's going to take me here.

5:06

I'm adding it to my restore bucket.

5:08

This is, I love to think of this as my shopping cart.

5:11

I'm just going to pick and choose what I'm taking back to my environment.

5:15

So, I'm actually excluding here the email addresses.

5:18

And so, I don't want you to go back to the users and ask them to reclaim these

5:23

again.

5:24

First names are going to be restored.

5:26

Full name is going to be restored.

5:27

Does this look about right for you?

5:29

>> Yeah, that's awesome.

5:31

>> Right. Let me ask you to preview that restore in here.

5:34

And then what's going to happen is that in a matter of seconds,

5:37

all of this data is going to be added to your environment.

5:40

The good changes are kept, the bad changes are reverted,

5:43

and all of your lost data is already back in your environment.

5:45

So, you can go ahead and tell your team that everything should be looking okay.

5:49

>> Right now, I can tell them?

5:52

>> Right now?

5:53

>> That's incredible.

5:56

Thank you so much.

5:59

All message my team right away.

6:01

>> Absolutely. And whenever you have time, we can go through within minutes

6:06

and actually set some parameters and smart alerts so that we can get notified

6:10

if something like this happens again and we don't need to know three weeks

6:13

after.

6:13

>> Yeah, that would be even better.

6:17

If I didn't have to come to you, that would be great.

6:20

>> Yeah, absolutely. Well, happy to help, Ellen.

6:23

Have a good day.

6:23

>> Thanks so much, Tonya, your own lifesaver.

6:26

>> Bye-bye.

6:28

>> Bye.

6:28

>> Bye.

6:29

>> Bye.