Forum Discussion

faustusxanthis's avatar
faustusxanthis
Frequent Visitor
1 year ago

File contains corrupted data issue

My dashboard is already published in PowerBI online. If I refresh the dashboard using desktop, the refresh completes without any error. I checked Power Query and no tables are showing any errors. However, when I refresh the said dashboard online or do a scheduled refresh, it always gives me a "DataFormat.Error: File contains corrupted data" error!

 

 

I checked the source file of the referenced table and the file loads just fine. There are no passwords or anything. The Excel file loads without any problem. 

 

I also checked the Power Query for the referenced table in Desktop and it's not showing any error. 

 

I'm wondering what could be the issue here? 

 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the replies from faustusxanthis.

     

    Hi faustusxanthis ,

     

    If your Excel file has any sensitivity labels, please set it to the lowest level possible, here's a thread with a similar problem for reference:

    Solved: File contains corrupted data - Microsoft Fabric Community

     

    Best Regards,
    Zhu

     

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

  • Could this be related to specific fields (like a date, date time, ...) contained in the file? It might use a different locale when processing on your local machine vs the service.

     

    you could troubleshoot by just keeping 1 column from the file (eg a string or an int) and refresh the dashboard in the service. That could point to the culprit.

    • faustusxanthis's avatar
      faustusxanthis
      Frequent Visitor

      I will check on this. Right now, I'm still having issues

  • Could you specify the path used when publishing to the service? Is this referencing an Excel file on a mapped drive (eg. Z:\myexcel.xlsx) or using a \\server.domain.com\myexcel.xlsx) ? Do you require a gateway? The service has to be able to reach the file

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi faustusxanthis ,

     

    Have you solved your problem? If it is solved, please share your solution and accept it as solution or mark the helpful replies, it will be helpful for other members of the community who have similar problems as yours to solve it faster. Thank you very much for your kind cooperation!

     

    Best Regards,
    Zhu