Forum Discussion
Need help with refresh data after connecting to excel file on SharePoint
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?
Solution SpecialistHi 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?
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.