Forum Discussion

ManchevB's avatar
ManchevB
Helper II
2 years ago
Solved

Ambiguous column name when using multiple sources

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    The error is caused by the way the stored procedure is written. Fix it in the SP.

ManchevB's avatar
ManchevB
Helper II
2 years ago

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.. . ğŸ¤”

lbendlin's avatar
lbendlin
Super User
2 years ago

The error is caused by the way the stored procedure is written. Fix it in the SP.

  • ManchevB's avatar
    ManchevB
    Helper II
    2 years ago

    I see, any suggestions where exactly I should check in the SP? - usually I have the SPs created for me, that's why I'm asking 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago
      any suggestions where exactly I should check in the SP?

      how would we be able to answer that without seeing the SP? It's in the SELECT statement ?