Forum Discussion
Solved
Expression.Error When refreshing an excel file from Sharepoint
Hello, I get this ExpressionError when refreshing a Dashboard, that pulls data from an excel file, linked to a very robust SharePoint. The dashboard was able to refresh data before, but no...
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.
danextian
Super User
Super UserHi DonovanJack ,
Many possible reasons:
- a missing or renamed worksheet (trailing spaces, text case changed)
- a missing or renamed column (trailing spaces, text case changed)
Please read this article for your reference - https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/
danextian .... there were columns added in the Power BI dataset that are not im the orginial source data. Could this be the issue? (Bucket Order and Week columns were added)