Forum Discussion
Helper VExcel Files contains Corrupted Data-Web Connection with Onedrive
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?
The Excel Workbook had a password on it. Removing that password somehow resolved the issue.
4 Replies
- amitchandak
Super User
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
ziyabikram96There 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.
- v-xicai
Community Support
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
The Excel Workbook had a password on it. Removing that password somehow resolved the issue.
