Keep getting error of "don't support reading encrypted workbooks" but my Excel book is not protected

[miayuxin]

I was working on a Power BI dashboard and when I tried to refresh my database, the message appears: "We don't support reading encrypted workbooks Power Bi"

But my worksheet is not protected by any password or something like that.

The only thing is this worksheet is located on an online excel (sharepoint) and shared with some people that have organizational accounts. And I was able to refresh it some months ago, but now I can't.

How to fix?

[Anonymous]

Hi @miayuxin ,

Hope I am not disturbing you, how is the situation now?

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[Anonymous]

Hi @miayuxin ,

How do you get data from excel file in PowerBI Desktop? Could you please provide screenshots of refresh setting page?

Best regards,

Mengmeng Li

[miayuxin]

I uploaded the excel files to Sharepoint, and import those excel files through sharepoint link on Power BI. 

Those excel files don't have any possword encrypted.

It works around 2 years, but suddenly it keeps running errors from yesterday. 

[Anonymous · Accepted solution]

Hi @miayuxin ,

I suggest you go to PowerBI Service to check if the connection to this excel file is Online.

If it is Offline, try to select "Edit credentials" in settings and verify the identity to restart the connection.

Check that your semantic model is using an online connection and unexpired credential, and then see if refreshing the semantic model can be successfully done.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[parry2k]

@miayuxin can you open it in Excel Online?

[miayuxin]

Yes. I can open it in excel online.