Forum Discussion
Expression.Error When refreshing an excel file from Sharepoint
Hi DonovanJack ,
Do you have access to the Sharepoint folder where that specific file is saved?
What you can do is to replaced your third step where it refers the Folder by the following code:
= Excel.Workbook(#"Filtered Rows"{[Name="EXcelFILENAME.xlsx"]}[Content])Then also delete the 4th step, this should work in the same way.
Super UserHi DonovanJack ,
Has danextian refered believe this is an issue about the name of the file being changed.
Just did a small test on a local folder and renamed my file and has you can see I have the same type of error:
MFelix .... the file name has not been changed in the SharePoint
- MFelix
Hi DonovanJack ,
Believe that something may have change in your path or file since you are having the error in the 3rd step that is before entering the file itself.
Did you by any chance changed the file from folder?
That specific step uses the path has a reference if you change the location of the file altough it's in the list because the source is at the highest level of the sharepoint folder the specific step does not work.
MFelix danextian amitchandak DataInsights
This is the Source step:
It doesn't point to the particular file it just pulls up all the files/types on the Sharepoint 😕
Not sure how to fix this issue, when I try to direct the source through the sharepoint list option (how the dashboard was set up) it says I can only use the root URL.*It is looking like I will have to redo this dashboard*