Forum Discussion
Presenting data from two child tables generate error
Hello, I am connecting to an MS access database that has the following table structure
tbl_inspection>tbl_Observation>tbl_observation_SOP—One to Many from Observation to ObservationSOP
tbl_inspection>tbl_Observation>tbl_observation_issue_subtype—One to Many from Observation to SubType
Where tbl_inspection is the parent table to tbl_observation. Table tbl_observation has two child tables: tbl_observation_SOP and tbl_observation_issue_subtype.
I have a table visual that displays data from tbl_inspection, tbl_observation, and tbl_observation_sop it gives me an error that PowerBI cannot determine the relationship between two of more fields.
The joins in the relationship diagram in PowerBI are correct and match the relationships in the MS Access database. See picture of relationships below
Here are the relationships between the tables
9 Replies
TomSinAA,
What version of Power BI Desktop do you use? In your scenairo, please drag the bridge fields of tbl_Observation table which you use to create relationships with tbl_inspection and tbl_observation_sop to the visual, and check if you still get the error.
If the issue still persists, please share sample data of the three tables and we need to know the detailed fields you use to create relationships.
Regards,
LydiaPlease change your releationship as below.
Regards,
Lydia
