Forum Discussion

ManchevB's avatar
ManchevB
Icon for Helper II rankHelper 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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That's an error inside the Stored Procedure.  Fix that there.

  • ManchevB's avatar
    ManchevB
    Icon for Helper II rankHelper 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
      Icon for Super User rankSuper 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
        Icon for Helper II rankHelper 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