Hi Nithin,
It is easy and simple.
1. Go to Power BI, Get Data -> Data Source -> select the tables while fetching data sources, then click on edit option to perform any ETL operations.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=7544718111229011753)
2. You can see list of tables on left side pane of Power Query Editor window.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=17255392462447644150)
3.Click on merge option ( as new).
![](https://www.edureka.co/community/?qa=blob&qa_blobid=5470465420609880213)
4.Select the 2nd table and select the column to join and the join kind .
![](https://www.edureka.co/community/?qa=blob&qa_blobid=14307443330467268802)
5.The Key column is shown in new table with (table) entry.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=12615464023645192076)
6. Select the columns to select the columns to add in new table created after join.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=13072706720965866604)
7. Columns are displayed as below. (<2nd table name>.<column name>). The new table can be renamed on the right side of the window.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=11123708459958528442)
hope this helps you.
Unlock your data potential with an affordable Power BI course fee! Enroll Now
Also Refer: How do you handle formatting issues when exporting Power BI reports to Excel or PDF, especially with large text tables?