OLE DB or ODBC error: [DataFormat.Error] The input couldn't be recognized as a valid Excel document.

OLE DB or ODBC error: [DataFormat.Error] The input couldn't be recognized as a valid Excel document..

When I am trying to refresh one of my Power BI desktop reports I am encountering this error. I have been using this report since months and I never encountered such an error.

There is no problem with my source excel file, and its the same file I have been using since a long time.

There are no hyperlinks in my excel file and no columns are hidden.

Can anyone please provide a permanent fix to this error?

Thanks!