Forum Discussion

Advocate II

10 years ago

Object reference not set to an instance of an object

So I have my PowerQuery working perfectly but when I apply and load the "Apply Query Changes" comes back with the error above. I'm not sure what is causing this but I may have a suspicion. My query...

Need Help

Anonymous

Not applicable

9 years ago

Hi, It took me a couple of hours to figure why Power BI wasn't creating the relationships out.

Error message was:

"Unexpected error Object Reference not set to an instance of an object". (Very informative)

Checked the data was clean, trying different data sources that were working before, etc. Then I tried creating the relationship in the other direction and it worked without any issues XD.

With that I mean when I drag and drop from Table A to Table B, the exception occurs; when I drag and drop from Table B to Table A, works.

Hope this helps!