Forum Discussion

t-taaror's avatar
t-taaror
Regular Visitor
7 years ago
Solved

Merging data from Different tables .

Hello.   I have 5 different tabls with the exact same schema and i am using Direct Query mode. One column in the table represents the Success or Failure. I want to create a pie chart representing t...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi t-taaror ,

     

    If the schema and columns name are same then you can use Append Queries to get all data in single table.

     

    Goto Edit Queries ==> Click on "Append Queries" ==> Select "Three or more tables"

    Select the tables which needs to be append. Then click OK. You can create a new table then check the data if that is what you needed.

     

    If this solves your problem mark this as solution and give khudos.

     

    Thanks

t-taaror's avatar
t-taaror
Regular Visitor
7 years ago

hi v-yuta-msft 

 

Actually i am new to PowerBi so could you please elaborate the solution. 

 

The scenario is like for example i have 5 tables each has 10 rows. one column has text value success or failure. I want to display the total success percentage(for the 5 tables) using PieChart. For that, i wanted to have a table with a single column having 50 rows

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi t-taaror ,

 

If the schema and columns name are same then you can use Append Queries to get all data in single table.

 

Goto Edit Queries ==> Click on "Append Queries" ==> Select "Three or more tables"

Select the tables which needs to be append. Then click OK. You can create a new table then check the data if that is what you needed.

 

If this solves your problem mark this as solution and give khudos.

 

Thanks