Forum Discussion

greglauder's avatar
greglauder
New Member
8 years ago
Solved

Merging Two Tables

Hi   I'm having trouble merging information into one table on power BI.    I have 3 tables which I work from which I work from   1. Policy 2. Motor Drivers 3. Motor Vehicles   They all have...
  • Anonymous's avatar
    Anonymous
    8 years ago

    if you're trying to normalize the data into 1 table, I recommending using the "Merge Queries" button in Query Editor to perform the merge and get the columns that you need into 1 data table.

     

    Relationships in Power BI should be used as a way to link a dimension table to a fact table.

     

    It sounds like you have 2 fact tables, and these should never have a relationship joining them.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

if you're trying to normalize the data into 1 table, I recommending using the "Merge Queries" button in Query Editor to perform the merge and get the columns that you need into 1 data table.

 

Relationships in Power BI should be used as a way to link a dimension table to a fact table.

 

It sounds like you have 2 fact tables, and these should never have a relationship joining them.