Forum Discussion
URGENT Help needed for Data Modeling
I have a scenario where I'm facing an issue in the data that needs to be corrected and that needs help on the data modeling side.
Here's an insight on it:
The visual right now with applying the required filters: The highlighted one is the name, but the name is updated in the backend side but that doesn't reflects here in the visual.
When I convert it in a table visual and add the required field, here's the result:
it shows 3 names; the yellow one is highlighted is the name that is expected in the chart, but it shows the other one highlighted,
I think there's something with the data modeling (one-to-many relationship), which I'm not able to figure out.
Can anyone please help? It will really be helpful to me.
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.
3 Replies
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 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.