Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,390 --> 00:00:00,700
OK.
2
00:00:00,740 --> 00:00:07,320
So up to this point we've talked about a number of the most important data transformation tools in query.
3
00:00:07,470 --> 00:00:12,570
Next up to round out the section I want to cover some important settings and options.
4
00:00:12,590 --> 00:00:15,590
And the first topic is data source settings.
5
00:00:15,660 --> 00:00:21,240
So in the Home tab of the query editor you see this option for data source settings that basically just
6
00:00:21,240 --> 00:00:27,260
allows you to view and manage all of the individual connections in your power by file.
7
00:00:27,270 --> 00:00:33,060
So in this example that we're looking at here we've got connections to a number of individual CSP files
8
00:00:33,510 --> 00:00:36,900
as well as a folder down there at the bottom of the list.
9
00:00:36,930 --> 00:00:42,870
Now the critical concept to understand about data source settings is that when you make a connection
10
00:00:42,870 --> 00:00:49,410
to a local file a file that's located on your computer power b I will basically take a snapshot of that
11
00:00:49,410 --> 00:00:56,640
exact file path to that exact file name and what that means is that if anything changes about your file
12
00:00:57,030 --> 00:01:03,230
if you rename it or if you move it to a new location that path won't automatically update.
13
00:01:03,240 --> 00:01:09,750
So what you need to do is go into these data source settings click change source and browse to the revised
14
00:01:09,750 --> 00:01:11,960
version of that file.
15
00:01:11,970 --> 00:01:18,780
So this is probably the most common issue that I see in power by people inadvertently rename a file
16
00:01:18,780 --> 00:01:23,660
or rearrange things on their desktop and accidentally break these file parts.
17
00:01:23,700 --> 00:01:26,280
But the good news is that it's a very easy fix.
18
00:01:26,370 --> 00:01:29,570
As soon as you understand how these data source settings work.
19
00:01:29,670 --> 00:01:30,660
So let me show you what I mean.
20
00:01:31,470 --> 00:01:33,990
So I'm here in the adventure Works report.
21
00:01:33,990 --> 00:01:39,480
Got my four tables at this point including that AWB sales table that's now linked to the folder that
22
00:01:39,480 --> 00:01:45,150
we created in the last video and you can either follow along with me here or you can just watch because
23
00:01:45,150 --> 00:01:50,160
we're not actually going to be adding new data or revising anything that we have just going to show
24
00:01:50,160 --> 00:01:55,680
you a demo of what happens when a file path does break in the way that we talked about.
25
00:01:55,680 --> 00:02:02,540
So an edit query is to open up the editor and as you can see all four of my tables look good.
26
00:02:02,660 --> 00:02:08,150
And when I drill into the data source settings button right here in the Home tab I can see these four
27
00:02:08,150 --> 00:02:14,690
connections in place my three individual CSP files calendar customers products and then that folder
28
00:02:14,690 --> 00:02:16,060
that we just created.
29
00:02:16,130 --> 00:02:19,370
So everything looks good everything's running smoothly.
30
00:02:19,370 --> 00:02:23,340
But now what if I accidentally changed one of those file names.
31
00:02:23,660 --> 00:02:28,430
So I mean Navigate to My actual source folder on my desktop.
32
00:02:28,430 --> 00:02:29,450
There we go.
33
00:02:29,450 --> 00:02:32,690
Here are my adventure work CSP files that I'm pointing to.
34
00:02:32,810 --> 00:02:37,750
And as you can see from my query list one of those files is the products file.
35
00:02:37,970 --> 00:02:47,190
So let's say I accidentally rename this file products to or something similar.
36
00:02:47,210 --> 00:02:53,430
Now when I minimize this window and return back to the query Ed when I click the product look up query
37
00:02:53,860 --> 00:02:56,850
and click this refresh preview tab.
38
00:02:56,850 --> 00:03:02,100
As you can see I get this error that says we couldn't find the file and if you read closely you'll see
39
00:03:02,100 --> 00:03:07,880
why it's because it's looking for the file with its original file name and location.
40
00:03:07,950 --> 00:03:12,140
Adventure works underscore products not products too.
41
00:03:12,180 --> 00:03:16,870
So the issue goes all the way back to the very first step which is the source.
42
00:03:17,040 --> 00:03:21,900
And again it's because power by recorded or locked in the exact file path.
43
00:03:21,990 --> 00:03:24,450
When I first created that connection.
44
00:03:24,450 --> 00:03:27,240
So I have two options to fix this here.
45
00:03:27,240 --> 00:03:33,510
Option one is simply to rename that file and remove the two that I added at the end.
46
00:03:33,510 --> 00:03:39,990
Option two is to drill into my data source settings find the trouble spot in this case the products
47
00:03:39,990 --> 00:03:48,290
line click change source and simply browse to the updated version which lives right here.
48
00:03:48,290 --> 00:03:58,040
Venture works products to press open and OK and now when I close this data source settings window go
49
00:03:58,040 --> 00:04:01,600
back to product look up and refresh once more.
50
00:04:01,640 --> 00:04:02,900
Now we're back to usual.
51
00:04:02,900 --> 00:04:08,330
So the source populated properly all of those applied steps are maintained.
52
00:04:08,360 --> 00:04:10,020
We didn't lose any information.
53
00:04:10,310 --> 00:04:12,490
And we're back right where we started.
54
00:04:12,500 --> 00:04:14,270
So pretty simple fix.
55
00:04:14,330 --> 00:04:19,730
We could leave things just like they are or to kind of show you the same process in reverse.
56
00:04:19,820 --> 00:04:23,660
What I'm going to do is change that finally back to its original form.
57
00:04:23,840 --> 00:04:32,870
So go to my desktop folder and then simply remove that too at the end of the file name close that window
58
00:04:33,650 --> 00:04:44,030
go into data source settings products to change the source and again browse back to the original named
59
00:04:44,150 --> 00:04:47,630
adventure works underscore products.
60
00:04:47,850 --> 00:04:53,120
OK close out the settings window and if I refresh.
61
00:04:53,390 --> 00:04:54,100
There we go.
62
00:04:54,110 --> 00:04:55,400
Everything looks good.
63
00:04:55,400 --> 00:05:01,400
So we haven't actually made any changes but hopefully that was a helpful demo for how to address those
64
00:05:01,400 --> 00:05:04,760
data source errors using the data source settings options.
6918
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.