Compile Data From Multiple Files In Power BI

RAKESH KUMAR

Transcript

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.

Category

Transcript

Recommended