Reply
Frequent Visitor
Posts: 4
Registered: ‎02-21-2017

Lab2 - creating relationships between Locations and Sales causes "Object reference not set" error

Hello,

 

I attempted to create a relationship between Locations and Sales after creating a new column in each, CountryZip.  I got the error above.  I ended up "Sending a frown" to report the error, but I was later able to create the relationship by following the steps, and that is what I want to ask about.

 

The steps say to create the two columns with the following signature: Country + ", " + Zip.  This worked; however, during the Excel course I was able to create CountryZip like this: Country + Zip, no spaces or other characters.  Why would Power BI throw an error when attempting to create a relationship between two tables where the CountryZip column is Country + Zip, but not Country + ", " + Zip?

 

Thanks

Highlighted
Member
Posts: 138
Registered: ‎03-10-2016

Re: Lab2 - creating relationships between Locations and Sales causes "Object reference not set&

The step is perfectly, you will get correct result if you follow the lab step.