Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dat updating problem

Hi,

 

I got the following error for every data update  or refresh:

 

 

I  checked all the tables one by one, all is ok. 

Could you please advsie ?

Many thanks in advance.

Tg

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank you. Finnally it was SQL server problem. 

4 Replies

  • Mikelytics's avatar
    Mikelytics
    Resident Rockstar

    Hi Anonymous,

     

    you did check each table in Power query in the data preview right by really refreshing the preview for each single table? if yes, then it looks like un unstable connection maybe?

     

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi  Mikelytics 

      Thank you for your reply.

      I had checked all tables , refresh them multiple times, tried different internet connection. I have this problem since 3 weeks now. 

       

      • Mikelytics's avatar
        Mikelytics
        Resident Rockstar

        Anonymous 

        Did you make a change in the Power Query logic?

        Did you try to connect to the table fro a fresh file without transformation logic? 

        Did maybe somebody change something in the cinfiguration of the SQL server?

        Best regards
        Michael
        -----------------------------------------------------
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
        Appreciate your thumbs up!
        @ me in replies or I'll lose your thread.