Forum Discussion
PowerBi duplicating records
Hi all! I have a problem and I simply cannot find the solution.I have a DirectQuery from Dataverse (Microsoft Dynamics), with a table showing funders and funding to different projects. From the same...
This would be more of a question for your data model. How does that look like between these two tables?
The two tables are linked on the unique key project ID - many to one.
If we imagine table A:
| fundID | fundName | projectID | projectName | State | amount |
| 1 | fundA | 3 | projectX | Active | 5 |
| 2 | fundB | 3 | projectX | Inactive | 2 |
| 3 | fundC | 4 | projectY | Active | 10 |
table B (with the duplicate record):
| projectID | projectName | startDate | endDate | State |
| 3 | projectX | 01/01/22 | 01/06/22 | Active |
| 4 | projectY | 01/04/22 | 01/04/23 | Active |
| 4 | projectY | 01/04/22 | 01/04/23 | Active |
The duplicate record does not show in Microsoft Dynamics, so I can't delete it or change state and filter from there.
Edit: For some reason the formatting comes out strange, so here is a screenshot: