DataFormat.Error: The input couldn't be recognized as a valid Excel document. Details: [Binary]

[Stuartm1983]

Hi,

I had a report that was working daily (>365 days) until today.

Today it no longer runs and has the error below.

Nothing has changed in the source or the PBI Report. Could somebody please help?

Thanks

S

[Stuartm1983]

Hi,

No still no solution on this, just had to use a workaround due to time constraints, I've identified it must be the file and not the connectors.

S

[v-shex-msft]

HI @Stuartm1983,

Ok, thanks for sharing the response about this issue.

In addition, if you can't find the root cause of this, you can also consider submitting a ticket to get further support from the power bi support team. (it is free for pro and above license)

Support | Microsoft Power BI
Regards,

Xiaoxin Sheng

[Stuartm1983]

Thanks but doesn't seem to explain. I'm working on it further, strange.

It's a Excel 365 document which is populated from a Power App if that helps explain?

S

[v-shex-msft]

HI @Stuartm1983,

I'd like to suggest you download the file to the local device and use an excel connector with that file to confirm if this issue is related to the data connector or the file itself.
Regards,

Xiaoxin Sheng

[v-shex-msft]

Hi @Stuartm1983,

Any update for these? Did the above suggestions help with your scenario? If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[filipeoliveira]

Maybe this help

https://techcommunity.microsoft.com/t5/excel/quot-the-input-couldn-t-be-recognized-as-a-valid-excel-...