DataFormat.Error: File contains corrupted data. Details: [Binary]

[Anonymous]

Hi,

In which case, do we normally get this type of error? 

let
// Get list of files in SharePoint folder
Source = SharePoint.Contents("https://nokia.sharepoint.com/sites/xxxxx"),
// Get list of files in SharePoint folder
Documents = Source{[Name="Documents"]}[Content],
// Get list of files in SharePoint folder
#"Rollout" = Documents{[Name="Rollout"]}[Content],
// Get list of files in SharePoint folder
#"Daily Report" = #"Rollout"{[Name="Daily Report"]}[Content],
#"Removed Other Columns" = Table.SelectColumns(#"Daily Report",{"Content", "Name"}),
#"Sorted Rows" = Table.Sort(#"Removed Other Columns",{{"Name", Order.Descending}}),
#"Kept First Rows1" = Table.FirstN(#"Sorted Rows",1),
#"Added Custom" = Table.AddColumn(#"Kept First Rows1", "Custom", each Excel.Workbook([Content])),
#"5G Site Status 20250210_20250214_All xlsx1" = #"Added Custom"{[Name="5G Site Status 20250210_20250214_All.xlsx"]}[Custom]
in
#"5G Site Status 20250210_20250214_All xlsx1"

[amitchandak]

@Anonymous , I think expand of excel step or excel data has some problem

Have you used expand binary icon in the last step  ?

Check if this can work

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

[Anonymous]

If I expand the error from Custom column, it looks like this.