Forum Discussion

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
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
7 years ago
TomSinAA,

Please change your releationship as below.

Regards,
Lydia

TomSinAA

Helper IV

7 years ago

Hello,

I created a simple MS Access database with 4 tables to use in Power BI. Table 1 is the parent table. Table 2 is a child to Table 1. Table 2 has two child tables. Table 3 and Table 4. when I get data is generates the following error: Value cannot be null. Parameter name:modelingRelationship.

There are no null values that I can detect. It also did not autodetect or create the relationships.

PBI fields from Access dbPBI errorMS Access relationships

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