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

[Anonymous]

I have a Power BI dashboard that uses multiple excel files stored in Onedrive as a dataset and day before yesterday got the following error while refreshing the data set -

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

Details: [Binary]

I have a Power App that is connected to these excel files as a data sources. Yesterday all of a sudden started getting the following error in one the screen which has a submit form operation -

Network error when using patch function: the requested operation is invalid on SubmitForm

The Submit Form operation is just taking the inputs from the UI elements and inserting in the excel file and no patch function is used explicitly.

When the Power BI issue occurred, I had manually corrected the data in excel file and saved it. Post that the Power BI issue got fixed but the Power App issue cropped up.

Based on the following link, the excel file is corrupted, even though I am still able to open it -

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

Since the excel file was saved in OneDrive, I had reverted it to a point where the app was working. Then the Power App issue was fixed, but again started getting the issue in Power BI.

Thus, not able to figure out how to make Power App and Power BI work simultaneously which was happening earlier and at the same time fix the corrupted excel file.

[Anonymous]

Hi @Anonymous 

I don't quite understand your question. When you mention Power App, do you mean the app generated by report and dashboard? If your report is displayed properly, it is usually published to the app and there is no problem. Maybe you can provide the corresponding screenshot?

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

Hi @Anonymous 

By Power Apps I mean the Microsoft Power Apps (https://powerapps.microsoft.com/en-in/) that is a part of the Power Platform Suite.