Forum Discussion

TomSinAA's avatar
TomSinAA
Helper IV
7 years ago
Solved

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_i...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    TomSinAA,

    Please unselect relationship options in your PBIX file, then re-open the PBIX file and apply changes. Then create relationships manually in the PBIX file.


    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    7 years ago

    TomSinAA,

    Please change your releationship as below.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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,
Lydia