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

[Vane]

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

[Vane · Accepted solution]

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]

How did you import it?

[Vane]

I chose "import from Excel". I must say tthe file has macros/VBA programing aplied.

[v-easonf-msft]

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.