Share via

Power query Error

Anonymous
2023-04-03T18:26:01+00:00

Hi Experts,

I have merged the tables in the power query. The results are displayed in Power query mode but I got the following error below

The Data Model table couldn't be refreshed:

Excel couldn't refresh the table 'RCS' from connection 'Query - RCS'. Here's the error message from the external data source:

Column 'CFN' in Table 'RCS' contains a duplicate value 'IBFTBX701' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. The current operation was cancelled because another operation in the transaction failed.

How to solve this issue?

Thank you in advance :)

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2023-04-04T00:13:46+00:00

    Hi,

    Though you see that error in the Query Editor pop up, that is actually a Data Model error. Go to the PowerPivot and delete the relationship which this table has with the other table. The refresh will work. If you wish to retain the relationship, then you will have to ensure that the CFN column does not have duplicates.

    0 comments
  2. Anonymous
    2023-04-04T13:30:54+00:00

    Thank you. Ashish. It worked

    0 comments
  3. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2023-04-04T23:00:46+00:00

    You are welcome. If my reply helped, please mark it as Answer

    0 comments