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? Could you please share the Access database file and share the steps you make in Power BI Desktop so that I can test?

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