Dynamic Dashboard

Hi Vrinda-0902​,

I’d first check where the workbook is stored and whether the sheet passwords are just protecting the sheets from editing or encrypting the entire file.

If the workbook is stored on SharePoint or OneDrive, Power BI can refresh from it without requiring users to close it, provided the file is accessible and the changes have been saved. If it’s stored locally, you’ll need to consider a gateway for scheduled refresh.

Sheet protection generally doesn’t prevent Power BI from reading the data, as long as the workbook itself isn’t encrypted. However, if the owners are editing the workbook simultaneously, refresh will only pick up the data that has been saved.

If each sheet is maintained by a different owner, I’d consider storing the data in separate files or consolidating it into SharePoint Lists or another central data source. This can make refresh and access management easier.