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
Highlighted
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
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.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021