Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create relationships between multiple data sources

Hi all,   I'm a new user in power bi and have, what I suppose to be, an easy-solved problem. I currently have four different data sources (country A, B,C,D) imported from excel. The four excel shee...
  • themistoklis's avatar
    5 years ago

    Anonymous 

     

    I would combine all tables into one. You can do that through Power Query Editor --> Home --> Append Queries --> Append Queries as new

     

    Before combining them make sure you add another column to each table and give them a specific name so as to distiguish its values from the other tables.