In addition to password protecting workbooks, Excel also supports restricting access based on users (ACL). It's a common practice to ACL workbooks in Excel to limit access to confidential data, that ...
I agree totally, I have the same situation and it is shame I can't connect to restricted excel files. Although I am using Power Query in excel, but I am sure it is the same for Power BI
