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 ,
Yes, I think it is a path issue but what is strange is that my collegue can refresh/update the data with no problem. The file is in the same location and path since we are using the same Power BI file.
I guess the current issue is....
Why can't I or other Users refresh and update the data in the Dashboard and only he can using the same Sharepoint URL root address?
- MFelix
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.
That worked to get the old data pulled from the orginal excel file, when I first saved the report to my computer, but it does not pull in the updated/current data in the sharepoint.lists excel file.
Is there something wrong with the code?
- MFelix
Has I refered do you have acces to the sharepoint folder? Can you go to sharepoint and open the file?