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

TomSinAA's avatar
TomSinAA
Helper IV
7 years ago

Lydia,

 

I am using version: Version: 2.64.5285.741 64-bit (November 2018)

 

I can share the MS Access database. and the Power BI file.  How do I do that?  I don't see a way to attach or add the file.

 

Thanks

Tom

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

TomSinAA,

You can upload files to OneDrive and post shared link of the files via Private Message.

Regards,
Lydia