Forum Discussion
Presenting data from two child tables generate error
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
Lydia,
The issue still persists. How do I share the sample data?
TomSinAA,
You can upload files to OneDrive and post shared link of the files via Private Message.
Regards,
LydiaTomSinAA,
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,
LydiaHello,
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
