I am attempting to upload a workbook that is being used in my Teams workspace, however when I first attempted to connect I received a 400 error message that indicated it failed to publish this workbook. I then tried moving it around, new folders then directly to SharePoint and then finally attempted this locally to no avail. I've used BI for over two years now and haven't ever experienced anything like this. I finally stood up a VM and installed Power BI Desktop and I could Get Data and import the Excel file as expected.
Unfortunately, this is an issue because I need to use the service and refresh from SharePoint or Teams. I will also likely need to connect through a gateway at some point. I wasn't able to find anything but one article where someone had experienced the same thing and they did not test in BI Desktop. Any ideas or thoughts anyone?