Original subtitles

OK.

So up to this point we've talked about a number of the most important data transformation tools in query.

Next up to round out the section I want to cover some important settings and options.

And the first topic is data source settings.

So in the Home tab of the query editor you see this option for data source settings that basically just

allows you to view and manage all of the individual connections in your power by file.

So in this example that we're looking at here we've got connections to a number of individual CSP files

as well as a folder down there at the bottom of the list.

Now the critical concept to understand about data source settings is that when you make a connection

to a local file a file that's located on your computer power b I will basically take a snapshot of that

exact file path to that exact file name and what that means is that if anything changes about your file

if you rename it or if you move it to a new location that path won't automatically update.

So what you need to do is go into these data source settings click change source and browse to the revised

version of that file.

So this is probably the most common issue that I see in power by people inadvertently rename a file

or rearrange things on their desktop and accidentally break these file parts.

But the good news is that it's a very easy fix.

As soon as you understand how these data source settings work.

So let me show you what I mean.

So I'm here in the adventure Works report.

Got my four tables at this point including that AWB sales table that's now linked to the folder that

we created in the last video and you can either follow along with me here or you can just watch because

we're not actually going to be adding new data or revising anything that we have just going to show

you a demo of what happens when a file path does break in the way that we talked about.

So an edit query is to open up the editor and as you can see all four of my tables look good.

And when I drill into the data source settings button right here in the Home tab I can see these four

connections in place my three individual CSP files calendar customers products and then that folder

that we just created.

So everything looks good everything's running smoothly.

But now what if I accidentally changed one of those file names.

So I mean Navigate to My actual source folder on my desktop.

There we go.

Here are my adventure work CSP files that I'm pointing to.

And as you can see from my query list one of those files is the products file.

So let's say I accidentally rename this file products to or something similar.

Now when I minimize this window and return back to the query Ed when I click the product look up query

and click this refresh preview tab.

As you can see I get this error that says we couldn't find the file and if you read closely you'll see

why it's because it's looking for the file with its original file name and location.

Adventure works underscore products not products too.

So the issue goes all the way back to the very first step which is the source.

And again it's because power by recorded or locked in the exact file path.

When I first created that connection.

So I have two options to fix this here.

Option one is simply to rename that file and remove the two that I added at the end.

Option two is to drill into my data source settings find the trouble spot in this case the products

line click change source and simply browse to the updated version which lives right here.

Venture works products to press open and OK and now when I close this data source settings window go

back to product look up and refresh once more.

Now we're back to usual.

So the source populated properly all of those applied steps are maintained.

We didn't lose any information.

And we're back right where we started.

So pretty simple fix.

We could leave things just like they are or to kind of show you the same process in reverse.

What I'm going to do is change that finally back to its original form.

So go to my desktop folder and then simply remove that too at the end of the file name close that window

go into data source settings products to change the source and again browse back to the original named

adventure works underscore products.

OK close out the settings window and if I refresh.

There we go.

Everything looks good.

So we haven't actually made any changes but hopefully that was a helpful demo for how to address those

data source errors using the data source settings options.