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

[agr0809]

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!

[v-yuta-msft]

@agr0809 ,

Please create a support ticket here.

Regards,

Jimmy Tao

[v-yuta-msft]

@agr0809 ,

Please check if the power bi desktop has been updated to the latest version.

Regards,

Jimmy Tao

[agr0809]

Yes, it is updated to the latest version.