Forum Discussion
URGENT Help needed for Data Modeling
Hi Poojara_D12
Make sure the relationship is active, one-to-many, and the key column on the "one" side is unique.
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledgeHi Poojara_D12 , Thank you for reaching out to the Microsoft Community Forum.
Your data model likely includes both old and new name entries and the visual is pulling from the wrong source, probably the fact table or a merged dataset. Even with a correct relationship, if the dimension table isn’t cleaned to keep only the latest name per ID, the outdated one can still show up.
To fix it, ensure your visual uses the name from a cleaned dimension table where each ID maps to a single, up-to-date name. In Power Query, filter the dimension to keep only the latest name per ID (e.g., using Group By with a max date). Then verify the relationship is active and based on ID. This will ensure your visual reflects only the current name.
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Hi Poojara_D12 , Thank you for reaching out to the Microsoft Community Forum.
Your data model likely includes both old and new name entries and the visual is pulling from the wrong source, probably the fact table or a merged dataset. Even with a correct relationship, if the dimension table isn’t cleaned to keep only the latest name per ID, the outdated one can still show up.
To fix it, ensure your visual uses the name from a cleaned dimension table where each ID maps to a single, up-to-date name. In Power Query, filter the dimension to keep only the latest name per ID (e.g., using Group By with a max date). Then verify the relationship is active and based on ID. This will ensure your visual reflects only the current name.
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.