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...
So far in Excel for web we may refresh connections only for the source which is in the same workbook (i.e. tables or ranges within it). External data connections are not refreshed. Doesn't matter you do that manually or by script.
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.