Dataset is refreshing but current data is not reflecting in the table

[Shellysethi]

Hello,

A report was published in service two years back and it was running fine. From Aug 2023 we were facing issue in the report. The table in the report is showing the data till 29th July 2023 and no reflecting the current data (i.e data from Aug and Sept). How to solve this issue?

[Shellysethi]

Thank you for the support.

[v-zhangti]

Hi, @Shellysethi 

Try the follow: `

• 1. check all the table queries, go to properties and be sure all have the update on refresh option seleccted, its just below the option for not loading the querie to the report. 
• 2. Check the gateway and update the gateway to the latest version.
• 3. Re Publish the PBIx to the service.

Install an on-premises data gateway | Microsoft Learn

Solved: dataset doesn't update when refresh - Microsoft Fabric Community

Solved: Dataset Refreshes but Report Does not - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.