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

xls missing first column

Hi. I have recive new bach of data from our web developers in xls format and meet strange begavior in power query grabber. 

 

I try to load single file and folder, but in both case i dosn't see first column of data in power query it become 5th and have null in data. 

Here is a sample of a file.

https://drive.google.com/file/d/1SobVktgXwPwagMp1uSTDQKohJuZW205o/view?usp=sharing

 

In xls it is look lile: 

c5QrwaO

 

In power query i found this resoult:

8e69fNl

 

 

If i change order of first two columls i lost data from first column anyway, and can't understad what reasont of that behavior. 

 

5 REPLIES 5
Jimmy801
Community Champion
Community Champion

Hello @Zaknafeein 

 

there are some weird problems when reading a xls-file. Maybe this file was also created by a 3rd party software.

So here some solutions to it

- try format your data as real table and then read the data from the table and not from the sheet

- try to open the file and save it as the same file once more

- save it as XLSX-file

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

PC2790
Community Champion
Community Champion

Can you share your Power Query code from Advanced Editor?

Also, not able to access the link provided.

Please share the sample file again 

Hi, here it is.

 

let
Source = Excel.Workbook(File.Contents("F:\PowerBi\Web\OrderInfo\2009-08.xls"), null, true),
Orders1 = Source{[Name="Orders"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Orders1,{{"Column1", Int64.Type}, {"Column2", type datetime}, {"Column3", type text}, {"Column4", Int64.Type}, {"Column5", type text}})
in
#"Changed Type"

Please share your sample file and excle workbook which is being used as a source

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.