Invalid column name after editing SQL

[ThiagoDuarte]

Hello,

I have a report running on a SQL base managed by other team in my company

There were some changes to the SQL database. A few columns were added. Now my report won't refresh. If I try to open and refresh it on Desktop application I get this error:

"rpp_deviceweight" is one of the columns that were added to the SQL (last update)

I reloaded this table from SQL server. This column is showing in my Power Query view and it's on my native query editor

Any ideas on how to solve it?

Thanks

[amitchandak]

@ThiagoDuarte , In the case of the latest version, power bi is able to handle add remove columns automatically. But in older version you may have handle it manually

How to manage when column is added or removed at source: https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2

[ThiagoDuarte]

I'm running on:

I think this is the lastest update. 

EDIT:

The solution on the video won't work

I'm using direct query

In advanced editor I can't see all the columns on my table. Instead I see this:

[v-easonf-msft]

Hi, @ThiagoDuarte 

Since you have made changes to the data in the data, it is best to recreate the report.

You can also refer to this related document to edit  M query in advanced editor.

DataSource-Error-Invalid-column-name 

Best Regards,
Community Support Team _ Eason

[Dimani]

Is there any new development in 2025?  I have the same issue after some columns were deleted from a underlying table, and the table in the report uses directquery.  And the deleted columns are not used in the report.

Is it possible to handle it without deleting the table and re-add it back, or without recreating the report?  I tried refreshing the data in the report, and it did not refresh the table structure.  The error stays.

[ThiagoDuarte · Accepted solution]

Hello

I think that might work but my report is way too big and complex to start from scratch.

I did get it to work though. I deleted all the tables that suffered any changes and then I reconected to them(direct query) . After that I recreated all the relationships (on these tables).

It works now!

Best Regards,

Thiago Duarte