Forum Discussion

duncfair's avatar
duncfair
Helper IV
2 years ago

Power Query shows errors if columns are dropped or re-named in SQl Server source after refreshing

These two columns were dropped from the source table. The columns drop seamlessly in the model after refreshing, but Power Query shows error. This is a new issue as I have done these sorts of changes literally hundreds and hundreds of times in the past without seeing this error.

General Comment
Need Help

3 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    Have you checked any previous steps depending on the step where you removed the columns ?

  • duncfair's avatar
    duncfair
    Helper IV
    2 years ago

    I did. That wasn't it. I needed to navigate to the report credentials, sign out and sign back in again.