Compile Data From Multiple Files In Power BI
Category
📚
LearningTranscript
00:00right so
00:02I will tell you in this video that
00:06we can see how many files are combined
00:12here is our folder year
00:16here is 2014-15-16
00:18here is
00:202014 data
00:242015 data
00:28this data is different
00:30I want to make this folder
00:32further
00:34I want to make this folder
00:36all the files are combined
00:38here is the year
00:40here is Power BI
00:42blank report
00:50blank report
00:52if I take Excel
00:54this data source
00:56here is the data source
00:58here is the Excel
01:00here is the
01:02CSV file
01:04here is the
01:06file
01:10here is the
01:12data source
01:14here is the
01:16file
01:18here is the
01:20file
01:22here
01:24here is the
01:25file
01:30here is the
01:32file
01:34now
01:36here is the
01:38file
01:40I will click on links and click on this folder Then click on zlambles.
01:47I will click on the description and click on I will click on the folder here.
01:53That you will see that there is three files there.
01:55I have done this, and now my power query will open.
02:02It is opened.
02:06It is shown in this way.
02:12My data is in binary.
02:14If I go here,
02:21the data is in binary.
02:30In this folder,
02:33I will copy and copy and copy.
02:39Sorry.
02:41Now you can see here.
02:46Now I will press refresh all.
02:53Now I will copy and copy and paste all data.
02:57If I can copy and paste all data,
02:59I will copy and paste all data.
03:01There will be error.
03:03I will close it.
03:05Then we will transform.
03:07What else should I do?
03:12We will insert a step.
03:15If I can follow it,
03:18then what do I do?
03:20I will create a step to delete until.
03:22Then I will press delete.
03:25I will create a step to delete.
03:30I am going to delete the group.
03:34When we import the steps, our data is in this place.
03:41I am going to delete the rest of the group.
03:45Remove the other column.
03:48Now the data is in this place, but it is in this place.
03:52So we need to remove the data.
03:55I am going to add column.
03:59I am going to add custom.
04:01There is a function called csv.document.
04:08Sorry, csv.document.
04:14It is gone.
04:20I am going to add this.
04:22And this content is inserted here.
04:27I am going to add bracket here.
04:29I am going to add no sentence error.
04:33I am going to add error.
04:34If I add one bracket, I will add error.
04:36I will add error.
04:37If there is error, I will check it out.
04:39Okay.
04:40Now the data is shown here.
04:42Now I am going to click here.
04:44You can see this data.
04:46This data is shown here in 2014, 2015, 2016 and 2017.
04:53I will compile this all.
04:56Now we have this two columns.
04:58This is two columns and our data is now.
05:00So we can now add this data.
05:02It has removed from here.
05:04Now it has got to be removed.
05:06Now it has got to be removed.
05:08Now we will expand this data.
05:10Now we will go back to this data.
05:14Now it has gone and
05:18OK.
05:20Now we will see.
05:22Now it has got to be removed.
05:24Now we will go back to the data.
05:26Now it has got to be removed.
05:28It is not that data came here.
05:30Oh God.
05:32Now our data has come.
05:34Now the data is coming.
05:36Here we can start to create anything here.
05:38What can we do about this data?
05:40We have to decide.
05:42Now we will decide from this data.
05:44Now we will decide.
05:52I am just taking this data.
05:54We need to take a year, now we can see that our data is in the future, see here you can see 14, 15, 16, 17,
06:13then we can see that our data is in the future, we can see that our data is in the future, so we can see that our data is in the future,
06:30so we can see that our data is in the future, so we can see that our data is in the future,
06:45so we can see that our data is in the future, so we can see that our data is in the future,
07:02so we can see that our data is in the future, so we can see that our data is in the future,
07:17so we can see that our data is in the future, so we can see that our data is in the future,
07:34so we can see that our data is in the future, it's in the future, as we can see that our data is in the future,
07:37so obtain we have a data to our data copy by leaving the per drop,
07:46so we can see that our data is in the future and then delete on its name,
07:50and remove and file our data by selecting the data,
07:54now then drag it into perspective and drag it and select,
07:58and now finally releases a new data up when using it,
08:02Now, see, this data has been 81.
08:09I will close and apply.
08:15Refresh of Ness.
08:20Now, see, here is all data.
08:25now what do I do in this folder
08:33there are two files in this folder
08:45there are two files in this folder
08:49here is the 14, 15, 16, 17 data
08:53why I did not have done that to order all files
08:57Now I will go to Home and refresh
09:02here is the only file file
09:05here are only 24 and 15 data
09:07I will be here
09:09so I will paste the file file
09:13and paste it
09:17now look at 2014-15-18
09:23all data
09:24now what happens is that
09:26all the file remains in this folder
09:29one or four or ten
09:32or 400
09:33and all the files will be able to get data
09:36compile
09:37now we will say that
09:40we will build a chart route
09:42we can connect a column
09:44We can remove the ear, we can remove the ear from here.