Forum Discussion

Escorial's avatar
Escorial
Regular Visitor
6 years ago
Solved

Refresh error


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

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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 

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    There are lots of things that can break the refresh like changing column names, table names, etc. Difficult to say with the information provided.
  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Escorial ,

     

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

     

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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