Forum Discussion
gameel1992
Oct 28, 2021Copper Contributor
Issue with pivot tables from data model
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 p...
gameel1992
Oct 31, 2021Copper Contributor
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
SergeiBaklan
Oct 31, 2021Diamond Contributor
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?
- gameel1992Nov 01, 2021Copper Contributor
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