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 sh...
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?

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