Forum Discussion

Shelley-Baynton's avatar
Shelley-Baynton
Helper I
4 years ago
Solved

Refresh Error - column does not exist in the rowset

Hello,

I have a few of my reports that have been working up until the last couple of days, now I'm getting the following error message:- 

 

 

I've carried out the following hoping to resolve the issue: 

 

  • Opened in Desktop and checked connected data, refreshes and flags no issues.
  • Disconnected reports from App, deleted and republished to Power BI online

 

But I'm still getting the same error, any help would be warmly welcomed 😀

 

EDIT: Updated data gateway as that was showing that it needed to be updated

 

Thanks

Need Help
  • ibarrau's avatar
    ibarrau
    4 years ago

    Hi. Try going one by one the tables in "Transform Data" or "Edit Query" menu clicking refresh preview. The error is usually shown when the source has change the name of a column or has deleted a column and later in the steps you have a single step referencing specific columns names (like rename, changetype, remove columns, etc)

    I hope that helps,

1 Reply

  • ibarrau's avatar
    ibarrau
    Super User
    4 years ago

    Hi. Try going one by one the tables in "Transform Data" or "Edit Query" menu clicking refresh preview. The error is usually shown when the source has change the name of a column or has deleted a column and later in the steps you have a single step referencing specific columns names (like rename, changetype, remove columns, etc)

    I hope that helps,