Forum Discussion
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...
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?
m_alireza
Solution Specialist
Solution SpecialistTamnguyen1109
No problem at all! No need to apologise. Happy to help.