Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

One to Many Table Relationship

I am extremely new to Power BI so please bear with me. So assume I have 3 XML sheets (my initial data sources for Power BI) and 2 of them are as simple tables as follows: The tables b and c repr...
Need Help
saurabh_kedia_'s avatar
saurabh_kedia_
Microsoft Employee
7 years ago

Hi,

 

If I'm understanding correctly there is more than one mapping required from different tables to one table, this itself should not be the issue. Although, if more than one mapping is required between both the tables, that can be an issue.

 

Can you please share the .pbix file or the .xml file for more data.

Feel free to reach me out at [email protected]

 

Regards,

Saurabh 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Saurabh, this is how my XML looks this. For Table A, the so called mother table:

    <?xml version="1.0"?>
<Software Name = "Company Software">
  <HeadProduct Name = "Google">
    <Product>Chrome</Product>
    <Product>Mail</Product>
  </HeadProduct>
  <HeadProduct Name = "Microsoft">
    <Product>Windows 10</Product>
    <Product>Windows 7</Product>
  </HeadProduct>
</Software>

    And the rest 2 tables are as follows:

    <?xml version="1.0"?>
<Catalog>
  <Room>
    <Name>Gibralter</Name>
    <Length>450</Length>
  </Room>
   <Room>
    <Name>Oak</Name>
    <Length>120</Length>
  </Room>
</Catalog>

    Please understand that at this stage of development I am ready to change the structure of the Table A, if the current XML structure is unfit for the purpose.

    • saurabh_kedia_'s avatar
      saurabh_kedia_
      Microsoft Employee
      7 years ago

      Hi,

       

      I think the two tables i.e. table A & B, should contain one more column for identifying the type of info for example it's a Mircosoft or Google in this case. Then these two tables can be merged into one table which then can me mapped to the first one. Although it will be a many to many relationship as the data is actually repeatative i.e. there is no direct mapping between both the tables.

       

      Regards,

      Saurabh