Unable to "Apply Query Changes".

[Peddakiran]

But when I click on "Close and Apply", I got following error msg.

Would you mind to explain me my mistakes ?

[v-qiuyu-msft · Accepted solution]

Hi @Peddakiran,

In your scenario, the issue can be caused by that the column "Country Name" contains distinct values before you change the query for table "Country Population", and this column is used as a primary key to related to another table with One-Many relationship. You can click the Manage Relationships button to check relationship definition like below:

In your scenario, if you want to apply the query change, you need to break the relationship between the table "Country Population" and it's related tables. After applying the query change, you can recreate the relationship between this table with others.

Reference:
Create and manage relationships in Power BI Desktop

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[KHorseman]

You have a relationship between this table and another table. One of those tables must have unique values for that connected column. If Canada shows up multiple times in both tables, you cannot create that relationship.