Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Get value by joining 3 tables

Need your help.   I have mapped 3 tables in power bi :- premium, claim_occ, clim_sfx.   Premium table has pol_id and claims_occ have pol_id along with clm_id and clms_sfx has claim_id.   select...
Show and Tell
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    The relationship between Premium table and claims_occ, claims_occ and clms_sfx are one-to-one, one-to-many or many-to-one? Have you uploaded the three tables to Power Bi desktop? If you haven't, where are they stored? If they're stored in SQL Server database, you can use the T-SQL directly in the SQL statement box when you import data.



    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

The relationship between Premium table and claims_occ, claims_occ and clms_sfx are one-to-one, one-to-many or many-to-one? Have you uploaded the three tables to Power Bi desktop? If you haven't, where are they stored? If they're stored in SQL Server database, you can use the T-SQL directly in the SQL statement box when you import data.



Best Regards,
Angelia