Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TomSinAA
Helper III
Helper III

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 tablesHere are the relationships between the tables

2 ACCEPTED SOLUTIONS

@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.
1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yuezhe-msft
Employee
Employee

@TomSinAA,

Please change your releationship as below.
Capture.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
v-yuezhe-msft
Employee
Employee

@TomSinAA,

Please change your releationship as below.
Capture.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lydia,

 

The issue still persists.  How do I share the sample data? 

@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.
1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 fields from Access dbPBI errorPBI errorMS Access relationshipsMS Access relationships

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

@TomSinAA,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@TomSinAA,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors