Visuals not updating after changing data in power query

[Rev999]

I built the dashboard based on the Power Pivot in Excel, the original data source is sql database. Every time I refresh data, the visuals are not updating.

For example, the power query latest data is 19/09/2025, the data is not show in the table view

[v-echaithra · Accepted solution]

Hi @Rev999 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @Rev999 ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[v-echaithra]

Hi @Rev999 ,

I hope the information provided is helpful. I wanted to check whether you were able to resolve the issue with the provided solutions. Please let us know if you need any further assistance.

Thank you.

[FBergamaschi]

What do you mean

For example, the power query latest data is 19/09/2025, the data is not show in the table view

Can you show this table view?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Rev999]

I filter the table view for the recent date, not data showing.

The latest available date is 12 Aug 2025. There no filter on the visual or page.

[v-echaithra]

Hi @Rev999 ,

Thank you for reaching out to Microsoft Community.

After refreshing your Power Query data, ensure that your Power Pivot model is also refreshed. Sometimes Power Pivot doesn’t update immediately after the data in Power Query is refreshed. In the Power Pivot window, click on the "Refresh All" button to make sure that all the data is updated.

As you mentioned filtering the table view for the recent date. Double-check the filters in Power Query to ensure that no older data or static filter is applied during the data load. If the filter is applied in Power Query itself, make sure it's updated correctly to reflect new data.

Check if the relationship between the tables in Power Pivot is set up correctly. If there is no proper relationship between the tables or if the relationships are incorrectly configured, it could result in data not showing in the visuals.

Sometimes Excel caches the data and prevents it from updating. To clear this cache: Go to Data > Queries & Connections, right-click your query and select Clear Cache.

Since you're working with dates, make sure that the date format in Power Query and Power Pivot is consistent. If the date is in text format, it might not match the filter correctly. Ensure that the "firstrecdate" field is formatted as Date in Power Query. Double-check the visuals in your dashboard. Make sure the filter applied within the visuals (or slicers) is correct and reflecting the updated data.
If none of the above works, consider rebuilding your visuals to reset any potential issues in the chart’s data binding.

Hope this helps.
Best Regards.