Forum Discussion

ThiagoDuarte's avatar
ThiagoDuarte
Helper I
5 years ago
Solved

Invalid column name after editing SQL

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 t...
Need Help
  • ThiagoDuarte's avatar
    ThiagoDuarte
    5 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

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

ThiagoDuarte's avatar
ThiagoDuarte
Helper I
5 years ago

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