Need help with refresh data after connecting to excel file on SharePoint

[Tamnguyen1109]

Hello everyone, I am a newbie here so I get so many troubles dealing with these connections. 
I want to refresh data after connectting to an excel file on sharepoint. I had connected successfully sharepoint excel file for the first connection on power bi desktop with connection through "Web" way. But after I update new data in sharepoint excel file, the excel file was locked and then the connection with power bi desktop is break because it showing up the error: "The file contains corrupted data".  I tried to reconnect by copy & paste the URL again (the first time I have chosen the Organization Account) but it still not works.
I have searched many topics and tried but it keeps happening. I don't know what is the issue and how to fix it. I hope that someone met the same situation can help me with this. Thank you so much for your help.

[m_alireza]

@Tamnguyen1109 
No problem at all! No need to apologise. Happy to help.

[Anonymous]

Hi @Tamnguyen1109 ,

Tried the method provided by Aireza? If it works, don't forget to mark his answer as a solution.

Referring to past threads, there are many reasons why this error occurs, please refer to these:

Solved: File contains corrupted data

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[m_alireza · Accepted solution]

Hi @Tamnguyen1109, to confirm, did you password protect the excel file? If yes, then no luck as Power BI does not work with password protected excel files...

But if its not password protected, then perhaps you can try the following:

Option A:
Open Power BI Desktop.
Click on Transform Data > Data Source Settings, find your web connection and click on Clear permissions. 
try connecting to the excel file again

Option B 
Create another copy of the excel file in your sharepoint site. Change your Power BI connection to the new excel file. See if it works?

[Tamnguyen1109]

Hi @m_alireza , I apologize for my delayed response. The past week has been crazy and busy for me.

I tried your way and it worked the first time. I was so happy, but then it happened again with the 2nd refresh. It seems I have to constantly do it manually and this will be inconvenient because I need to report auto refresh. It seems the problem is coming from sharepoint security because I have shown the company IT department your answer, and they are working on a fix for this issue.
However, if I have no problem with security, your approach is the best way.

Thank you so much for your help, you are so kind. Again, I'm very sorry for the late response.