Reply
Occasional Visitor
Posts: 1
Registered: ‎01-14-2017

Not able to load the data after editing,primary key error

After  editing the data as said..not able to load to power bi desktop..it throws error msg showing  column 'country Name' in table 'country population' contains a dupilcate value 'canada' and this is not allowed for columns on the one side of a many -to-many relationship or for columns that are used as the primary key table.

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

Re: Not able to load the data after editing,primary key error

Could you provide which module or lab and step? It is very diffcult to locate your problem.

Frequent Visitor
Posts: 8
Registered: ‎03-07-2017

Re: Not able to load the data after editing,primary key error

Lab 1 Excersie 3.  I have the same problem.

 

It's right at the end of the query editing when you goto Power BI desktop to view the Data.

 

    • Set the Data Type of both the Year and Population columns to Whole Number.
  1. Load the data into Power BI Desktop.
  2. Explore the imported data in the Data View. I assume our relationships are out of alignment but do not know how to correct them.  Please help! 
Frequent Visitor
Posts: 8
Registered: ‎03-07-2017

Re: Not able to load the data after editing,primary key error

Note I was still able to answer the questions successfully but these lab instructions need to be far more precise. 

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

Re: Not able to load the data after editing,primary key error

If you finish all exercises, you will see the table relationships like this as below:Lab1_relationships.png