cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular 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
Post Patron
Post Patron

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.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Kudoed Authors