cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kharras1 Frequent Visitor
Frequent Visitor

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

1 REPLY 1
Highlighted

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.