Refresh Error - column does not exist in the rowset

[Shelley-Baynton]

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

[ibarrau · Accepted solution]

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,