Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found.

[sakusuma]

I am getting this error while refreshing the datasets that are Sharepoint hosted CSV datasets from 17 hours or so.

Below is the error:

Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found.
Details:
ID=2452
PermMask=0x7ffffffffffbffff
FSObjType=0
HTML_x0020_File_x0020_Type=
UniqueId={8211460E-F710-4DB5-900F-52FD23E32CB7}
ProgId=
NoExecute=1
ContentTypeId=0x01010007892615EE788F46B32840A3F5335754
FileRef=/teams/makebidashboard/Shared Documents/DataFiles/Inventory Visibility/Device70WIP_20200922080055.csv
SMTotalSize=648457
File_x0020_Size=648033
MediaServiceFastMetadata=
_CommentFlags=
FileLeafRef=Device70WIP_20200922080055.csv
_ShortcutUrl=
_ShortcutUrl.desc=
_ShortcutSiteId=
_ShortcutWebId=
_ShortcutUniqueId=
Created_x0020_Date.ifnew=
File_x0020_Type=csv
File_x0020_Type.mapapp=ms-excel
HTML_x0020_File_x0020_Type.File_x0020_Type.mapcon=SharePoint.OpenDocuments
HTML_x0020_File_x0020_Type.File_x0020_Type.mapico=icxls.png
serverurl.progid=1https://microsoft.sharepoint.com/teams/makebidashboard/_layouts/15/Doc.aspx?sourcedoc=%7B8211460E-F710-4DB5-900F-52FD23E32CB7%7D&file=Device70WIP_20200922080055.csv&action=default&mobileredirect=true
ServerRedirectedEmbedUrl=
File_x0020_Type.progid=SharePoint.OpenDocuments.3
File_x0020_Type.url=FALSE
CheckoutUser=
CheckedOutUserId=
IsCheckedoutToLocal=0
Modified=9/21/2020 5:02 PM
Modified.=2020-09-22T00:02:03Z
Modified.FriendlyDisplay=0|September 21, 2020
Created=9/21/2020 5:02 PM
Created.=2020-09-22T00:02:03Z
Created.FriendlyDisplay=0|September 21, 2020
ItemChildCount=0
FolderChildCount=0
A2ODMountCount=
_ComplianceTag=
owshiddenversion=1
ContentVersion=1
DocConcurrencyNumber=1
_VirusStatus=0
Restricted=
SiteUrl=https://microsoft.sharepoint.com

[dhirendra59]

Remove the filter/sort step from your transformation step/m-query and it should work

Remove this step:

#"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx"))

[jillw]

I have the same error but this line isn't in my m-query. The extension column is showing all errors and none of my filters or transformations reference the extension column. 

[jillw]

I found the line of code in the Helper Queries - Sample File. Once I removed that line in the m-query the report refreshed as usual.

[sherry_amelse]

Same error here just in the past couple days.  Anxiously awaiting an explanation and/or fix...

[dhirendra59]

Remove the filter/sort step from your transformation step/m-query and it should work

Remove this step:

#"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx")),

[sherry_amelse]

Thanks!  I was just figuring this out when your reply came through.  For whatever reason, the extensions are no longer polulating in the document list and are all instead showing up as 'error'.  Removing this step fixed it!  Thanks for your timely reply!

[djinhkamei]

I have the same error coming up on this - would like to know what the error is.

[dhirendra59]

I am getting the same error. No issues before this. 

[Erika_S]

I am getting the same error, and am also connect via sharepoint folder to excel files. Did anybody managed to find a way to fix this error? 

[npnigro]

We are seeing this error too. Anyone from Microsoft have more information to share? I don't see it logged on Office 365 Admin Center and have reported it to Microsoft. We have dozens of queries that rely on this working. 

[npnigro]

Looks like it's been fixed by Microsoft. 

[Bsngr]

I also was getting this error. Worked around it for now by deleting the filter that filters the Extension Column and instead added a filter to the name column for example

Text.Contains([name], ".csv")

Maybe this helps until we get an official answer.

Best regards!

[Anonymous]

I've the same issue for 2 days now

[bugs84]

Hello, I am getting the same error too.

I am reading from sharepoint folder CSVs and XLSXs; everything was working fine up to the day before yesterday, from today I cannot refresh anymore...

[lpetty421]

I am getting the same error.

Re: Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found. 

Just saw it today, Jan 23, 2021.  

Everything was working fine Jan 22.  Now, all of a sudden, I am getting the error:

I have Power BI connected to Excel Files via a SharePoint Folder connection.  Also, the Extension column is now showing all errors.  

[v-maxsil]

I am getting the same error message when trying to access an Excel file hosted on Sharepoint, first noticed it earlier today.

Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found.
Details:
ID=3
PermMask=0x1b03c431aef
FSObjType=0
HTML_x0020_File_x0020_Type=
UniqueId={4ACCF3CB-3881-4D7A-8B70-7F702F89168D}
ProgId=
NoExecute=1
ContentTypeId=0x0101003F7C8701C31FA345828E4C7FEE808558

[sakusuma]

removed the m-query