Forum Discussion
Cannot export data from expected dataset in relationship situation
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.
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
2 Replies
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 AdvanceThank 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
