Sharepoint not retrieving an Excel column where the first row under the header is null!

[Vogels]

Hi PBI-Community,

I'm trying to do a Combine.Files method over a series of Excel files with the same data model out of a Sharepoint.Files retrieval.

It correctly works except the 14th column doesn't load into PowerQuery.

However, when I put a 0 in the cell under 'sales price gross', then Power Query does retrieve the whole column!

The weird thing is, when I load the same Excel file into Power Query locally (so not from SharePoint), it retrieves the 'sales price gross' even when it's empty.

I found putting a 0 in there as a work around, however it only works for my sample file in the combine.files query, not for all the other files....

Does anyone have an idea on how to fix this?

Thanks already!

Kind regards,

Vogel

[lbendlin]

delete all the automatically added changed type steps.

[Vogels]

I tried this, doesn't work. When I add a 'test' column next to the last one, the 'sales gross price' suddenly does get imported...

[Icey]

Hi @Vogels ,

Please check if this post could help you: Error when SharePoint list is empty.

Not the same but may help you.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.