Forum Discussion
undefinedData source errorDataFormat.Error: We were unable to load this Excel file because we couldn
Hi vzbkb1,
Thank you for reaching out to the Microsoft fabric community forum.
Please confirm if the file is saved in .xlsx format only older formats like .xls may not work well. Check if the Excel file has any broken links, hidden sheets, or damaged data.Try removing the connection to this file in Power BI Desktop, connect it again freshly, and then publish the report once more.
Also, in Power BI Service, please check the dataset settings and make sure that the SharePoint connection is using “Organizational account”.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.
Hi, you may try manually open the problematic Excel file in Desktop, then re-save it to SharePoint. Make sure to keep the file name the same and keep it in the same Sharepoint folder and just open and re-save/ overwrite the old one.
Not 100% sure it will fix the issue. when similar issue happened here this is what i normally do.