Forum Discussion
Script not working
Hello, I have an excel sheet which has two sheets in it which has pivot tables and i have created a script to refresh the data. The data is coming from power bi dataset. " function main(workbook...
But the sheet1 is getting refreshed. Only the sheet2 is not getting refreshed.
Sorry, I missed with Power Query refreshed. With PivotTable table only it shall work. As for refreshing being on Desktop I'd uncheck background refresh, but on Web it shall be unchecked by default.
Sorry again, have no answer.