Forum Discussion
Invalid column name after editing SQL
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
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
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:
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 _ EasonHello
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
