0:00
Welcome back. So we have seen how to append the Excel tables. We have seen how to append CSV files, but this time I'll show you how to append cross database
0:10
One Excel, one CSV, one PDF, one SQL. So different data sources you can append one below the other. Same technique. Okay. So you see what I have is I have this file which I've created earlier. This one was appending Excel tables. 4.2 was appending CSV file. But this time I'll show you how to append CSV with Excel file
0:30
That's very simple here. What I've done is I have created one folder append queries, append files from different data source
0:36
One is CSV and second is Excel file. Jan and Feb. Data is very same there
0:41
You see? If I just double click and open, name date and sales, same data I have
0:45
And here also if I double click and open, here also will be getting name date and sales
0:49
So nothing different in this. So what I want is I want to append 10 plus 10 records from both the files and bring into Power BI
0:57
So first thing is I can just click on GERN. data and now I cannot select folder option I should select as Excel then CSV and then do
1:06
it so I'll just click on this button as Excel and open that folder 4.2 or 4.3 maybe
1:13
and pick up this Feb Excel 2020 and click on open so from this particular file
1:19
there are multiple sheets multiple table but I'll select this particular sheet because
1:23
I have only one option here I'll select that and then I can just click on load
1:28
button why load button because I don't have anything to clean here I'll just click on load
1:32
button same way the second file I pick up that a CSV file so on the right side meanwhile you can see the file will be visible Feb 2020 now get data and this time I pick up CSV file and it was Jan 2020 this one open and here I can
1:51
also click on load button. I'll just click on load button. So both the files I have loaded
1:56
and these are visible on the right-hand side. But I don't want this files, I want to append
2:00
those different data sources. Now, you see, you cannot differentiate whether it is a CSV file or
2:05
it's an Excel file. All these things are now queries. Any 99
2:09
data source you can pick up into Power BI they will be known as queries. They'll
2:13
not be differentiated. It's an Excel it's a CSV. No. So you see
2:17
these are all queries now. Now if I want to go back, I'll just click on
2:21
transform data, this option. Transform Data. And here the same technique I'll be using. I'll go on the right
2:27
hand side, select the option as append queries as new. And here
2:31
it will ask me there are two tables. Definitely there are two tables. So I'll select
2:35
the first one as Table 1, not Table 1, that is the Feb 2020 and second as Jan 2020
2:43
The sequence can be anything. I'll just click on OK button. So once you click on OK, that's the 20 records which I have
2:49
And on the right hand side, I can just change this appended different data source
2:58
Different data sources enter. So that's different data sources which are appended
3:02
Now I can just click on Close and Apply. So if you observe, there's nothing new technique
3:06
Only thing is you have to just bring one by one different data sources and you can append
3:10
So it can be excellent CSV we have shown you here. It can be SQL, Oracle, big data, PDF, website, any data source you can bring and you can append here
3:19
So I hope you have understood how to do that in Power BI. That's all for this video
