Missing Data

[itsmevalhi]

Hello , I was wondering if someone could help? I am trying to retrieve column Airline_1 on the query and am unable to find any help online. 

If you can see the picture below shows Column Airline_1 this file is my March file and I am not sure why it is returning null values if I have data in my original file. 

I also attached a pic of my Feb query info and it is displaying the data correctly for Feb but not March

Query Data: 

= Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Month", type date}, {"Card", type text}, {"REF#", Int64.Type}, {"J/E REF #", type any}, {"Wire Transfer Request Date", type date}, {"Bank Acct ", type text}, {"Date Acct Debited", type date}, {"Beneficiary", type text}, {"Airline ", type text}, {"Airline _1", type text}, {"Supplier ", type text}, {"Amount in Local Currency ", type any}, {"Amount in USD ", type any}, {"Amount by Airlines", type any}, {"Amount Bill by airline ", type any}, {"Amount Billed ", type number}, {"Invoice #", Int64.Type}, {"Date Billed", type date}, {"Date Consolidated", type date}, {"Questions", Int64.Type}, {"Status", type text}, {"Notes", type text}, {"Diff", type number}, {"Dropdown", type text}, {"Billed Status", type any}, {"Unbilled", type number}})

[m_dekorte]

Hi @itsmevalhi,

What's the data source you're connecting to?

If for example you're using Excel files and your data (range) isn't defined by an excel table, but you're loading worksheet content there is a possibility of bringing in blank rows/ columns.

[itsmevalhi]

I am loading from Excel Workbook, when I do 1 power query per file all the data transferrs, when I append I automatically get null for the values in that column from the third workbook. When I do a query all at ones with all files same thing that third file does not transfer and I confirmed that it does have data.

Not sure what to do next and I am unable to find much online

[m_dekorte]

Here's a link to the excel connector reference:

https://learn.microsoft.com/en-us/power-query/connectors/excel

I want to call out these secions to help you resolve the issue. Again best practice is to define your range in an "Excel Table" and connect to that instead of connecting to a worksheet.

Unexpected null values 

Missing or incomplete Excel data