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.
This is something that I have already tried, but it does not work 😞
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 vzbkb1,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.