Excel Files contains Corrupted Data-Web Connection with Onedrive

[ziyabikram96]

Hi,

I am trying to establish a connection with an excel file via Web Connection shared with me on onedrive but, it has thrown an error saying file contains corrupted data. What could be the problem here?

[v-xicai]

Hi @ziyabikram96 ,

There may be an issue about the Power BI Desktop. You may need to install and reinstall the latest version of Power BI Desktop, see the similar cases :File contains corrupted data.

Best Regards,

Amy 

Community Support Team _ Amy

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

[ziyabikram96 · Accepted solution]

The Excel Workbook had a password on it. Removing that password somehow resolved the issue.

[amitchandak]

@ziyabikram96 , hope you are following these steps

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

OPen edit query/ data transformation mode, You should get some additional error. What is that.

See if you can fix some of those

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

[ziyabikram96]

There won't be anythong in data transformation mode as there is no data source. The problem occurs at the very first step where you have to copy the URL of that excel file.

I also tried to connect to the same file locally but it threw the same error. I guess, the problem is with the excel file.