Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
piotr_gor
Helper II
Helper II

Why Power Query sees one excel file as error?

Hi there, 

I try to connect to sharepoint specific folder, grab all of the files, merge then and do some other stuff with it. I use code as below: 

let 
Source = SharePoint.Files("https://my-company.sharepoint.com/sites/My-folder", [ApiVersion = 15]), 
#"Filtered rows1" = Table.SelectRows(Source, each Text.Contains([Folder Path], "First")), 
#"Added Custom" = Table.AddColumn(#"Filtered rows", "Custom", each Excel.Workbook([Content])) 
in 
#"Added Custom"

 

In some strange reasons power query sees last file as Error.

piotr_gor_0-1661149263391.png

 


Structure of all files are exactly the same, in the last file there is only less rows. 

Does anyone have an idea how to overcome my problem?

3 REPLIES 3
mussaenda
Super User
Super User

Hi @piotr_gor ,

 

what is the error showing when you clicked beside the error.

Do not click directly on the error.

 

Dataformat.error external table is not in the expected format

I found a solution. I mean it's just a workaround but if I open file, don't change anything and save it before uploading on SharePoint it doesn't raise an error.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.