Forum Discussion

Vrinda-0902's avatar
Vrinda-0902
New Member
3 days ago

Dynamic Dashboard

Dear all, I have to make a PBI dashboard that is connected to an excel workbook which has multiple sheets. each sheet has an owner and that sheet is password protected. the purpose is to get that da...
Need Help
DaniyalKhaleel1's avatar
DaniyalKhaleel1
Icon for Resolver II rankResolver II
3 days ago

You can build a Power BI dashboard connected to a multi-sheet Excel workbook without asking each sheet owner to close their sheet every time the dashboard refreshes.

The key is to determine where the workbook is stored and what “password protected” means. Excel sheet protection usually prevents editing cells; it does not encrypt the workbook's data. Power BI may still be able to read the data, depending on the protection type and connector.

Solution

- If the workbook is stored on SharePoint or OneDrive, connect Power BI to the cloud file and configure refresh.

Microsoft Learn

- If each worksheet is only sheet-protected (password required to edit cells), try connecting through Power BI Desktop.

- If the workbook is encrypted with a password to open, Power BI Service refresh may fail. Remove file-level encryption if permitted, or move the data into SharePoint Lists, Dataverse, or SQL.