Can't display the data because Power BI can't determine the relationship between two or more fields
Although above-mentioned error in the subject line looks common issue with others and I tried to read the existing threads but could not fix my issue by following threads. Relationship of the data model looks as follows:
Now I am trying to bring in Application ID from Application table, Preferred_Name_formula from Account table and it worked fine. However, when I tried to bring in other columns from other tables then it throws an error message as shown in following picture:
I tried to bring in AuhorisationEffectiveDate column of ECR Authorisation table and it gave me an error. Any help to fix the issue would be really appreciated?