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

[Anonymous]

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

[Anonymous]

@Anonymous,

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


Regards,
Lydia

[Anonymous]

@Anonymous 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]

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.

[Anonymous]

@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]

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]

Hi @Anonymous, 

Thank you, this worked for me

@Anonymous, it seems like we found solution. Thank you anyway,