Forum Discussion
Data omit issue while using one to many relationship
I have added two tables in Power BI with one to many relationship, Added fields from both tables. But If the related data is not available in second table, then the data from the first table is not showing in the table. Please help.
6 Replies
Hi Anonymous ,
If there are two model relationships between the two tables? Please ensure it is using active relationship.
Please refer to the following document.
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Super User
Hi,
Share some data, explain the question and show the expected result.
https://drive.google.com/file/d/18BRxeuBptzCPp_kr7_Z8nZD9G1tS0V9E/view?usp=sharing
I have shared pbix file with sample data. Please check Ashish_Mathur
- Ashish_Mathur
Hi,
I do not know what you are trying to do or what those 3 different datasets represent. I think you should first standardise the headings in the 2 datasets - INV Qty and PL Qty and then append those datasets. Then create a relationship (Many to One and Single) between the Inv column of the appended dataset and the SO Qty table.
Hope this helps.
