Oct 28 2021 12:13 AM
I have noticed lately an issue with excel the pivot tables don't update from the data model.
data model refreshes data from external sources like SQL correctly but the changes don't reflect on the pivot tables in the sheet, despite refreshing many times.
note: enable background refresh is disabled for all the queries
Oct 31 2021 03:49 AM
Oct 31 2021 08:04 AM
Hi ,Martin
thanks for your reply
I have already checked for that ,there are no protections
the weird thing is that the same sheet was working good but lately this issue happened without me changing any thing
Oct 31 2021 09:35 AM
Do you understand correctly that's only PivotTable doesn't return update information, but if to check data model, e.g. in Power Pivot, queries update data model itself?
Or nothing is updated, includes data in data model?
Nov 01 2021 04:21 AM - edited Nov 01 2021 04:25 AM
yes exactly , the queries update the data model but some pivot tables are not updated. Despite refreshing the pivot table itself many times .the only way to solve the issue is to delete the pivot table and recreate it and in some cases after a few successful refreshes the issue appears again