Simple Relationship Build Issues

Hi Anonymous ,

Based on your description, yes you will have to manually create relationships under "Manage Relationships" options.

The reason is, Power BI not always creates relationships automatically if it doesn't have confidence in creating them or may be found data ambiguous. But, in most cases it creates relationships.

In you case try setting relationships manually and see how it goes.

For more details on relationships, you can refer this article:

https://www.sqlchick.com/entries/2015/11/7/why-is-my-relationship-inactive-in-power-bi-desktop

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati