Forum Discussion

Tamnguyen1109's avatar
Tamnguyen1109
Frequent Visitor
3 years ago
Solved

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

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.

data protection
Need Help
  • m_alireza's avatar
    m_alireza
    3 years ago

    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?

4 Replies

  • m_alireza's avatar
    m_alireza
    Icon for Solution Specialist rankSolution Specialist
    3 years ago

    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's avatar
      Tamnguyen1109
      Frequent Visitor
      3 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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