01-14-2017 12:49 PM
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.
03-14-2017 02:33 PM
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.