Forum Discussion
Solved
Ambiguous column name when using multiple sources
The error is caused by the way the stored procedure is written. Fix it in the SP.
6 Replies
That's an error inside the Stored Procedure. Fix that there.
Do you know where exactly the error could be?
The Stored Procedure done in SQL uses the same columns, with the same names I have in the other 2 sources. I tried renaming them in the Power Query editor but nothing changed.. . 🤔
The error is caused by the way the stored procedure is written. Fix it in the SP.
Hi Ibendin,
Thank you for pointing me in the right direction, we ended up re-writing the SQL connection and renamed the columns in the Stored Procedure so that there is no conflict.
