Cannot export data from expected dataset in relationship situation

[Coolpearl]

I have setup relationship between 2 datasets. it is many to one type. 
when I export data, I want to export from dataset that has 'many' records, but power bi is exporting from dataset that has 'one' record. Relationship is based on concatenation of 2 columns in each dataset, "flag+employee_id". 
please advise how can I tell power bi to export from "many" dataset. Thank you.

[Akash_Varuna · Accepted solution]

Hi @Coolpearl Could you try these please 

• Use Fields Only from the "Many" Dataset: Ensure your visual includes columns from the "many" dataset, not the "one" dataset.

• Create a Merged Table: Use Power Query or DAX to merge the "many" and "one" datasets into a single table and use it for your visual.

• Export Underlying Data: Choose the "Underlying data" export option to ensure raw data from the "many" side is included.

• Adjust Relationships: Verify your concatenation key (flag + employee_id) is correctly set up and unique on the "one" side.
  Another way would be to create a calculated table in DAX and use that in a vsiual and export that something like this

ExportTable = 
SELECTCOLUMNS(
    FILTER(
        RELATEDTABLE('ManyDataset'),
        'ManyDataset'[Condition] = TRUE
    ),
    "Employee ID", 'ManyDataset'[EmployeeID],
    "Flag", 'ManyDataset'[Flag],
    "Other Field", 'ManyDataset'[OtherField]
)

If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[Coolpearl]

Thank you.  It's huge dataset so I can't merge tables.  User has agreed not to export data so my issue is as of now I will not need to work on it but I'll use this approach in future and see how it goes