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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Error Message: Value cannot be null. Parameter name: modelingRelationship

Hi, I have this error appearing when I try to load the data. I started to get it after I updated PBI Desktop to the latest version. Before it was working fine. Please, help me:


Frown (Error)

Error Message:
Value cannot be null.
Parameter name: modelingRelationship

 

Thanks

 

Status: New
Comments
v-yuezhe-msft
Employee

@Anonymous,

In SQL Server Management Studio, you can right-click on your table and select "Script table as->Create to".
1.PNG

Regards,
Lydia

Anonymous
Not applicable

@v-yuezhe-msft the whole process:

 

1. Click Refresh the Data

2. Loading Queries window opens

3. Data comes smoothly to queries

4. Trying to Detect Relationships window is loaded

5. The error is thrown

AMPAllie
Helper II

Downloaded new PBI version and unchecked "Autodetect new relationships after data is loaded".  Refreshed a report and no error. Saved, reopened, rechecked "Autodetect" and all is working fine.

v-yuezhe-msft
Employee

@Anonymous,

I test your process with my sample tables, but I am unable to reproduce this error on my side. Please share T-sql statement here or use AMPAllie's workaround .

Regards,
Lydia

Anonymous
Not applicable

This is also an issue for me but I turned off the Autodetect new relationships after data is loaded option in File | Options and Settings | Options | CURRENT FILE | Data Load | Relationships and it's working now.

Anonymous
Not applicable

Hi @Anonymous, 

 

Thank you, this worked for me

 

@v-yuezhe-msft, it seems like we found solution. Thank you anyway,