Forum Discussion
Table relationship - option greyed
Hi, I am new to the community and quite new to PowerBI so my question is pretty basic! I am trying to create a one-to-many relation between two tables but this option is greyed. Can someone guides...
Hi
Make this relationship active
When checked, the relationship serves as the active, default relationship. In cases where there is more than one relationship between two tables, the active relationship provides a way for Power BI Desktop to automatically create visualizations that include both tables.
There can be only one active relationship and many inactive relationship between two tables.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.