Forum Discussion
Power BI is creating duplicate entries
I have 2 data sources from Excel for my report connected with a Many to many relationship on one of the columns (Client Name). When I try to visulise the data in a table and I select fields from both...
Hi Anonymous ,
This is because you have multiple [start date] for a single client in Table A. When you put the [start date] to Table B, Power BI cannot determine which date this client corresponds to. In this case you will need to add an index column for both tables and use the index column as a one to one relationship instead.
Best Regards,
Jay
mh2587
Super User
Super UserChange the relatioship to one-to-many
then check it
Power BI wont let me chose one-to-many as there are multiple entries on both data sources.