Overview
The final report creating in this article is effectively the same as that from [KB461], but here we use PowerBI and its features.
Collecting the Data
1. Connect to the Database
2. Choose three tables/view using Navigator: RPT_TestCases, RPT_Incidents and RPT_TestCase_Incidents
3. Click on Transform Data before loading
![](/Support/Attachment/139386.aspx)
4. You can select and remove all the fields that not being used in this report so to keep it as clean as possible:
![](/Support/Attachment/139387.aspx)
Merging Queries (JOIN operation)
5. In Transform window click Merge Queries, choose the Test_Case_ID column (that is the unique key parameter ) to match in the Test_Case_Incidents table with the same Test_Case_ID column:
![](/Support/Attachment/139391.aspx)
6. Click on the double arrow button within the header of column just added into this table and choose Incident_ID to add:
![](/Support/Attachment/139393.aspx)
7. Repeat the operation to add the missing information from Incidents table with the difference that now we're matching Incident_IDs from RPT_Incidents table:
![](/Support/Attachment/139394.aspx)
8. Choose the Name and Status to be added into this table:
![](/Support/Attachment/139395.aspx)
Building the Table
9. Click Close&Apply
![](/Support/Attachment/139396.aspx)
10. Create a table and choose the columns in desired sequence:
![](/Support/Attachment/139397.aspx)