Data source SQL table is not up to date!!

[Matt_Gol]

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? 

[Matt_Gol · Accepted solution]

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

[Matt_Gol]

@Luuky  @amitchandak  Any helps is highly appreciated

[Tahreem24]

@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]

@Tahreem24 Thanks for your message.

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

[Tahreem24]

@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]

No nothing. If I apply any filter here, it does show on advance editor, doesn't it?