You can follow these steps:
- Click on Transform Data
- Locate the table that is not refreshing properly.
- Right click on the table name
- select Enable Load (Uncheck).
- After a while again Right click on the same table and select Enable Load
- Close and Apply
- Refresh the dataset now