Forum Discussion
File contains corrupted data after October 2018 update
Hi RazvanSer
I can reproduce your problem.
encrypt an excel file
connect this excel file to power bi desktop
It should note that Power Bi desktop doesn't support to import data from password protected Excel file currently.
Here is an idea you could vote it up.
If you need the excel file to remain protected/encrypted in some way, you could remove passsword and instead, move the files to a secure folder that limited people have access to.
Reference: power query accessing password protected workbook
Best Regards
Maggie
Hi v-juanli-msft,
Thank you for your reply.
Unfortunately, all excel files that I use are automatically encrypted by a security software (company policy), they are not password protected, so even if I move these files to a secure folder they will end up being encrypted anyway...
What is curious is that in the previous version of PBI I didn't have this issue...this started after Oct update...and I don't have/find the install kit for September version to see if installing that version will solve the issue...
Thank you for your help!
Razvan
Hi RazvanSer
Did you remember how you get data from these files with previous version?
Do you need to enter some credential for the data source?
Or does the security software give permission for your power bi account?
How about sign in with your power bi account and get data later?
Best Regards
Maggie
Hi v-juanli-msft,
I just loaded the data from excel without any credentials. I didn't even had to sign in to load data...it just worked as it was.
To be honest, I don't have a power BI account.
Thank you for your help,
Razvan