Missing last Column after Importing Excel (.xlsx) dataset

[But_why]

Hi All,

I'm getting sales data in the form of excel xlsx files dumped into a SharePoint from an external company. Recently my report has been failing as the last column is not being picked up by Power BI. I expect 35 columns however only 34 columns are loading into Power BI.

Test - 

I manually downloaded an older file (File A) from this SharePoint (when the report was working) and a newer file (File B) and loaded both of them into a completely new/clean Power BI report and the same issue happens.
Results -
File A will load with all 35 columns however File B will be missing the last column and only load 34 columns.

The weird thing is, if I open File B in online Excel and close it immediately after making no edits (file autosaves) - the file will load into Power BI correctly with all the 35 columns present.

Any idea why this is happening and how to get Power BI to pick up this column (as it used to) without me having to manually go in and save it every day?

In the attached image below - Original File B shows the columns that should be visible. File B shows what I'm actually getting in Power BI with column 35 (or Discount %) missing.

[Syndicate_Admin]

I have exactly the same problem and it is driving me crazy, any solution?

[Anonymous · Accepted solution]

Hi  @But_why ，

Please try to do the following opertions and check if they can help you resolve the problem.

• Create a excel file and copy the data from File B into it, then connect this new excel file in Power BI and check if the last column can be displayed
• Check if there is any applied steps in Advanced Editor to "stop" the displaying of the last column
• Refresh the data in Power Query Editor

In addition, the following links are the threads which have the similar problem as yours. Hope the solution can help you resolve the problem.

Solved: MIssing last column in Power Query - Microsoft Fabric Community

Hi, just to add that as a workaround I have found that my adding an additional 'unwanted' column at the end of my reports that I am importing this then in part resolves the problem as that column now being the last is being ignored and the one I need is not!

powerbi - Missing column in Power BI - Stack Overflow

---

You could have accidentally deleted it...

Go to Transform Data to get tot he PowerQuery editor.

Click on the relevant table and then look at the APPLIED STEPS. Click on each one from the bottom up to preview the data at the selected steps to see where it has gone wrong.

Also check your data source - has it disappeared from there maybe?

Best Regards