Forum Discussion

Matt_Gol's avatar
Matt_Gol
Helper I
3 years ago
Solved

Data source SQL table is not up to date!!

Hi everyone

I faced a weird issue today. I connected one table from the SQL data source to my dataset and suprisingly, it doesn't have all the records. Any idea what is happening? 

 

Need Help
  • Matt_Gol's avatar
    Matt_Gol
    3 years ago

    That was very silly. I tried to add the table by using Get Data>> instead of Recent resources and it fixed!!!

6 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    3 years ago

    Matt_Gol That's bizarre. Please check below two things,

    1 - Click on "Refresh Preview" option and after refresh completion  then check the numbers.

    2 - Did you check is there any filter applied by any chance at Power Query end.

     

    • Matt_Gol's avatar
      Matt_Gol
      Helper I
      3 years ago

      Tahreem24 Thanks for your message.

      I already tried that and also there is no filter on the query

       

      • Tahreem24's avatar
        Tahreem24
        Super User
        3 years ago

        Matt_Gol Could you also check if there is any filtered applied in the "Applied Steps" section on the right most pane in Power Query Editor.

  • Matt_Gol's avatar
    Matt_Gol
    Helper I
    3 years ago

    That was very silly. I tried to add the table by using Get Data>> instead of Recent resources and it fixed!!!