How To Generate Reports From Merge Table In Power BI

Introduction

 
Before reading this article please go through my previous article () . In the previous article I have shown you how to import two tables from SQL Server and merge them into a new table.
 
You may also choose from one of the other join types as mentioned below:
  • Left Outer (all from first, matching from second
  • Right Outer (all from second, matching from first)
  • Full Outer (all rows from both)
  • Inner (only matching rows); this option was available previously through “Choose only matching rows” option in Merge dialog
  • Left Anti (rows only in first)
  • Right Anti (rows only in second)
See the below image to understand about these joins. Here two circles represent the two tables and the place filled with red shows the common data. 
 
How to Generate Report from Merge Table in Power BI
 
In my previous article I have used Left Outer Join condition to merge tables.
 
Now our task is to use this new table and create a report. At the end of the previous article we have applied the changes and saved them. Once the changes have been made and all those table were saved from Power Query Editor, our home page of Power Bi Desktop will be shown like the below image.
 
How to Generate Report from Merge Table in Power BI
 
Please follow the below steps to create a report with a new table, ‘BusinessAddress’.
 
Step 1
 
Here in this table we have 5 columns ‘AddessTypeID’, ‘Name’, ‘Rowguid’, ‘ModifiedDate’ and one new added column; i.e., ‘City’.
 
Now go to the City column and drag it into the report canvas. You can see a map visualization on the canvas. Blue marked on the map is showing the locations of different cities that are the value of the City column.
 
How to Generate Report from Merge Table in Power BI
 
Step 2
 
To create another report, I am using ‘AddressTypeId’ and ‘Name’ column and selecting the ‘Stacked Column Chart’ for visualization.
 
How to Generate Report from Merge Table in Power BI
 

Summary

 
This article is the sub-part of the previous article. I have given a short description about joins so that you can choose any of joining conditions to merge the tables as per your requirement. I hope you are now clear on how to use merge table and able to create a report from it. You may also use more visualizations according to your requirement. Also, you may merge two or more tables like this.
 
To make the report effective you can change the field name as I have shown you in my previous articles. Stay with me to learn more about Power BI.