Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure

One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. However, this feature occasionally doesn’t work as expected. One of these situations is when your Excel file is password protected. In this post I’ll show you what happens when your Excel file is password protected, what error do you receive in Power BI, and how to fix this issue and continue successfully with importing your model into Power BI.

Read rest of the article here: https://radacad.com/power-bi-issue-fix-import-from-excel-workbook-contents-password-protection-failure