Share via

Help Needed with Power BI Data Modeling

Maria Jonas 0 Reputation points
2024-08-14T09:24:22.4166667+00:00

Hi everyone,

I am currently working on a Power BI project and could use some advice. I have a dataset with multiple tables, and I am trying to create relationships between them. However I am running into issues where my relationships are causing data duplication or blank values in my reports.

Can someone guide me on the best practices for setting up relationships between tables in Power BI. Specifically I am curious about when to use a one to many relationship versus a many to many relationship and how to handle situations where there is not a clear primary key.

Any tips examples or resources would be greatly appreciated

Thanks in advance

[Maria]

Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
810 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Allie 230 Reputation points Microsoft Employee
    2024-08-21T21:32:26.15+00:00

    Hi Maria,

    I'd recommend also posting this question on the Power BI community here: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.