cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sakusuma
Microsoft
Microsoft

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

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

1 ACCEPTED SOLUTION
sakusuma
Microsoft
Microsoft

The reports are getting refreshed automatically. There might have been a correction from the product group side. will post the fix if I get it from the support team

Reply from Support team:

There was a change in Sharepoint service that caused this issue, this has been since resolved and the issue is mitigated. Sharepoint team deployed a kill switch to turn on legacy data fields. Please check the issue is persisting or not and let me know the update

View solution in original post

37 REPLIES 37
dhirendra59
Helper I
Helper I

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"))

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
Frequent Visitor

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
Regular Visitor

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

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")),

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
Regular Visitor

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

dhirendra59
Helper I
Helper I

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

Erika_S
Helper I
Helper I

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? 

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. 

Looks like it's been fixed by Microsoft. 

Bsngr
Frequent Visitor

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!

I've the same issue for 2 days now

bugs84
Frequent Visitor

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
Advocate I
Advocate I

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.  

 

lpetty421_0-1611455402626.png

 

v-maxsil
Microsoft
Microsoft

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
Microsoft
Microsoft

removed the m-query

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors