Error when publishing Power BI report to web version with no identified corrupted file in anywhere

[Pujoni]

I have a query connected to a Sharepoint site, in the documents part, I created a folder where I put several .xlsx files and consume them for Power BI. In Power query, I do a treatment and combine these worksheets. In the desktop version it works fine, updates and does not generate errors. When publishing to the web version, the following error appears: 

File contains corrupted data.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

How can I solve this? I have no idea how to identify such a corrupted file, because Power Query or PBI Desk does not show an error!

Error:

File in Sharepoint:

Query in Power Query:


Status query in Power BI Web: (Last line)

[v-yueyunzh-msft · Accepted solution]

Hi , @Pujoni 

According to your description, when you publish it to Power Bi Service , it returns an error code "File contains corrupted data.. ".

For this issue , it  may happen in the Power Query Editor.

You can open it in Power Query Editor and you need to check whether there is this error in each step, especially the step of converting the file to binary after reading SharePoint, you can check whether the file read in this step corresponds to the file in your Sharepoint, if there are some error files, you can try Filter it out.

And i search some similar error code link , i hope it may be helpful:
DataFormat.Error: File contains corrupted data. Details: - Microsoft Community

Solved: DataFormat.Error: File contains corrupted data. - Microsoft Power BI Community

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly