Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Map visuals: more data (bubbles) showing than expected

Good day! I have a summary “Table” visual that shows some ‘Events’ for a ‘Scheduler’ [should be notified] for the ‘Pipelines’ they work on.. E.g. there are 3 events for a scheduler, XYZ. Now, I have ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi  lbendlin 

The many-to-many relationship between the events and schedulers [same for the other one]  was selected by Power bI. When I try to change the relationship for events and schedulers to be many to 1 considering many events can happen to one pipeline [1 scheduler takes care of 1 or more pipeline(s) ], it doesn't let me change the relationship [PFB]

 

Thanks. ~Sohana

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

That means you either have a data quality issue in your data, or you may need to rethink the entire project.  Generally you want to have a data model that is at least resembling a star or snowflake schema, with "dimensions"  on the one side of a relationship and "facts" on the many side.