Failed to save modifications to the server. Error returned: 'The total number of columns in the mode

[Natthacha_65016]

Hi all 

Hope someone can help me for this

I try to load data from excel file. I have only 27 columns in this sheet but this error message show below:

I've loaded data from another sheet in this excel file which have 34 columns into this Power BI file, it was not found error.

Additional information, I have four sheet in excel file. And navigator show this four names.

[Natthacha_65016]

@DataInsights Thank you very for your help

I can get data from excel

[DataInsights · Accepted solution]

@Natthacha_65016,

In Excel, convert the data to a table. Then, in Power BI, connect to the Excel table (not the sheet).

Or, you can press Ctrl-End in Excel to go to the last used cell, and delete blank columns.