Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Expression.Error: A primary key already exists on the given table type.

Hi, The setup of my Power Query is this: 1) A single query to a SQL Server connection. The connection has a SQL statement that is query folded back to the SQL Server. This query is named BaseTable....
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

For your scenario, please refer to this similar thread which has been solved firstly.

In addition, for your error messge, I will suggest that you could duplicate BaseTable query and do the calculation instead of referencing the BaseTable query directly.

ImkeF  any other ideas?

Best Regards,

Cherry