Forum Discussion
Presenting data from two child tables generate error
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.
Regards,
Lydia
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
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,
LydiaLydia,
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