Any ideas on why the pivot app does not update with new data in the source?
I have a pivot sheet set up to pull data in from a report. The initial set up worked perfectly and when I run the configuration manually, the data is pulled in. But when the runs hourly (Update Frequency is set to 1 hour), no updates are made. All config logs show "Success!" but new data is only added to the pivot sheet if I manually run the pivot workflow.
What am I missing?