Forum Discussion
undefinedData source errorDataFormat.Error: We were unable to load this Excel file because we couldn
- 1 year ago
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.
I have deleted the file from the sharepoint, and saveit again (exactly the same file). I republish the PowerBi again also, and now I am able to refresh the PowerBI. Many thenaks for the help