BUG: SharePoint.Files + Excel.Workbook loads data but fails during model load

Hi ferdilda,  

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Kagiyama_yutaka, pallavi_r, for those inputs on this thread. 

Thanks for clarifying. If the file is stored only in SharePoint Online, then it is expected that you won't be able to access it through File.Contents, as File.Contents requires a local or network file path and cannot browse SharePoint document libraries. That would explain why the file does not appear when attempting to use File.Contents, even though another user reported being able to load the workbook using that method.

Given that the data previews correctly in Power Query, there are no row-level errors, and another user was able to load the workbook through File.Contents, the workbook itself does not appear to be the issue. I would recommend testing the same file using SharePoint.Contents instead of SharePoint.Files, as SharePoint.Contents navigates directly through the document library and can help determine whether the behavior is specific to the SharePoint.Files connector. If the file loads successfully through SharePoint.Contents, that will strongly suggest the issue is related to SharePoint.Files rather than the Excel file or query transformations. Additionally, clearing the Power BI Desktop cache and re-authenticating the SharePoint data source are worthwhile steps to rule out any cached connection or credential-related issues.