can't import data from a password-protected workbook!

Hi there. When importing from a excel file i get this error but the file é not protected with a pw!

Vane
5 years ago
although when importing the error appears as a password-protected file, the truth is that it was a macro problem. i had to extract the sheet with the data I wanted through VBA to a clean file and then import. thank you all

Gabriel_Walkman
Continued Contributor
5 years ago
How did you import it?
- Vane
  New Member
  5 years ago
  I chose "import from Excel". I must say tthe file has macros/VBA programing aplied.
  - v-easonf-msft
    Community Support
    5 years ago
    Hi, Vane
    
    PowerBI doesn't support to connect to protected excel files with Power BI directly.
    
    Given that passwords are not that secure in Excel anyway (there are many tools online that can crack Excel passwords), it is suggest to delete them and move these files to a secure folder accessible to restricted people.
    
    You can also vote up this idea .If there are enough votes, the Product Team will evaluate and take good consideration about it.
    
    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Vane
New Member
5 years ago
although when importing the error appears as a password-protected file, the truth is that it was a macro problem. i had to extract the sheet with the data I wanted through VBA to a clean file and then import. thank you all

Forum Discussion