Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

HELP! How to fix Expression.Error

Hello,   I have been trying to automate Data Cleaning and Transformation for a while now and I think I may have figured a solution, but when I hit refresh, my queries showed several errors and this...
Need Help
Show and Tell
Tutorial Requests
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,
    Can't really tell with the data you have given us, but when I run into that sort of error, it is in Power Query due to the steps that I took. Go back to the beginning and walk through your list of steps. You may have had a Column 1, and then changed the name as part of a step being inserted. If this is the case subsequent steps will still look for Column 1.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,
Can't really tell with the data you have given us, but when I run into that sort of error, it is in Power Query due to the steps that I took. Go back to the beginning and walk through your list of steps. You may have had a Column 1, and then changed the name as part of a step being inserted. If this is the case subsequent steps will still look for Column 1.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes! This actually helped. Took a bit of time to go back and retrace my steps but my queries are working now. Thank you!

    • Nathaniel_C's avatar
      Nathaniel_C
      Community Champion
      6 years ago

      Hi Anonymous ,
      You are welcome!

      Nathaniel