Data Load Erroring out Too Many columns

Hello IkeWelsh ,

 

what I may suggest that there are blank columns that are being read from the excel, check in power query how many columns you have, and if there are these blank columns then use the choose columns option to only choose the columns you want.

 

https://youtu.be/HIS_brYNpnI?si=DBFZjCcgEb11mBCI

 

Hi IkeWelsh ,

 

Hope everything is going well.

 

The error message reads: "The total number of columns in the model is 16457, which exceeds the limit of 16000."

 

Although your actual number of columns is only 8, it shows 999+ columns in Power Query.

 

You can remove blank columns in Power Query by following these steps:

 

Open Power Query, hold down Ctrl and select the 8 columns you need, select Remove Columns>>Remove Other Columns on the Home tab.

 

After deleting the blank columns, check other tables in the model to see if there are similar issues and if so, follow the same steps to delete the blank columns.

 

After cleaning the data, close the Power Query editor and apply the changes. Then, refresh the data model to ensure it reflects these adjustments.

 

Another possible cause of the error is a name conflict between the worksheet and the table.

 

If it has the same name as a worksheet, Power BI will rename the table name when connecting to the Excel file. It may cause this problem.

 

If you have any further questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!