All language subtitles for 15. Configuring Power BI Data Source Settings

af Afrikaans
ak Akan
sq Albanian
am Amharic
ar Arabic Download
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bem Bemba
bn Bengali
bh Bihari
bs Bosnian
br Breton
bg Bulgarian
km Cambodian
ca Catalan
ceb Cebuano
chr Cherokee
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
ee Ewe
fo Faroese
tl Filipino
fi Finnish
fr French
fy Frisian
gaa Ga
gl Galician
ka Georgian
de German
el Greek
gn Guarani
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ia Interlingua
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
rw Kinyarwanda
rn Kirundi
kg Kongo
ko Korean
kri Krio (Sierra Leone)
ku Kurdish
ckb Kurdish (Soranî)
ky Kyrgyz
lo Laothian
la Latin
lv Latvian
ln Lingala
lt Lithuanian
loz Lozi
lg Luganda
ach Luo
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mfe Mauritian Creole
mo Moldavian
mn Mongolian
my Myanmar (Burmese)
sr-ME Montenegrin
ne Nepali
pcm Nigerian Pidgin
nso Northern Sotho
no Norwegian
nn Norwegian (Nynorsk)
oc Occitan
or Oriya
om Oromo
ps Pashto
fa Persian
pl Polish
pt-BR Portuguese (Brazil)
pt Portuguese (Portugal)
pa Punjabi
qu Quechua
ro Romanian
rm Romansh
nyn Runyakitara
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
sh Serbo-Croatian
st Sesotho
tn Setswana
crs Seychellois Creole
sn Shona
sd Sindhi
si Sinhalese
sk Slovak
sl Slovenian
so Somali
es Spanish
es-419 Spanish (Latin American)
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
tt Tatar
te Telugu
th Thai
ti Tigrinya
to Tonga
lua Tshiluba
tum Tumbuka
tr Turkish
tk Turkmen
tw Twi
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu
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.