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
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