The source data for the pivot table changes daily. I would like to automate the refresh of pivot table using Office Scripts and Power Automate. Tried recording the change of source data, but code editor shows 'unsupported event'.
So my question is - what is the syntax to change source data for pivot table using Office Scripts?