Refresh error

[Escorial]

Hello ! I have a problem refreshing my data model..

I connect to a Mysql database; yesterday IT added new information and removed 2 empty tables from the database that I did not use or have in the model.

Today when I update my data I receive many errors and several.

I have requested a backup of the database and everything works correctly for me.

What can make it fails?, what could be the reasons? someone add new columns? Remove them?
Any idea?

thanks a lot

[v-gizhi-msft · Accepted solution]

Hi,

Please try to remove the 2 empty tables(which were removed yesterday) queries in Query Editor.

After Apply&Close, try to refresh again to check.

Best Regards,

Giotto 

[mwegener]

Hi @Escorial ,

it is best to refresh the preview in the Power Query Editor and see which query & step leads to the error.

[Greg_Deckler]

There are lots of things that can break the refresh like changing column names, table names, etc. Difficult to say with the information provided.