Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

This would be more of a question for your data model. How does that look like between these two tables?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    The two tables are linked on the unique key project ID - many to one.

    If we imagine table A:

    fundIDfundNameprojectIDprojectNameStateamount
    1fundA3projectXActive5
    2fundB3projectXInactive2
    3fundC4projectYActive10

     

    table B (with the duplicate record):

    projectIDprojectNamestartDateendDateState
    3projectX01/01/2201/06/22Active
    4projectY01/04/2201/04/23Active
    4projectY01/04/2201/04/23Active

     

    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: