Excel Online: Pivot Table not refreshing

Christopher Sundar I am having the same issue, and I think it's because the 'Enable Background Refresh' option is turned on for the query connections. This is what I found:

When we have the “Enable Background Refresh” property enabled, we are telling the system that every time we ask it to refresh the Power Query query, we authorize the system to move on with other tasks, without needing to wait for that query refreshing process to be complete.

The pivot table shows a summary of the data in the Power Query table. However, the system is not waiting for the Power Query table to be finished with the data updating before starting with the pivot table’s updating process. Therefore, the pivot table is being refreshed at the same time as the Power Query table is. Because the two processes start around the same time, the pivot table is not updated correctly because the data it has access to at the beginning of the refreshing process has not been updated yet with the most current information.

When the property “Enable Background Refresh” is disabled:

If the property “Enable Background Refresh” is disabled, the system will refresh the Pivot Table query first, and when the table is updated the pivot table gets also updated with the new information.

This way, both the Power Query table and the pivot table get refreshed at once.

I am yet to see if this works for my case but wanted to provide the info here in case it helps!