Impossible to load an xlsx file from Sharepoint. Getting various errors.

Hi,

I am trying to achieve what, in my opinion, should be a very simple thing - to fetch an xlsx file from Sharepoint and load it into PowerBI.

Somehow it doesn't work for me. Here's what I've tried:

First of all, I am using the "SharePoint folder" data source in "Get Data" in PowerBI. If I copy the link to the Sharepoint group / team I want to access the file from, then I get the following error:

Details: "The input URL is invalid. Please provide a URL to the root of a SharePoint site, or to the service document or entity of its OData feed (with no query or fragment part)."

So what I do is shorten the link. If initially it looked something like this (modified the link for security reasons):

(I modified the beginning part of the links, because I kept running into "incorrect HTML detected" when trying to post this post, which I couldn't fix. Seems like a Community page bug.)

https : //ourcompanydomain . sharepoint . com/:u:/r/sites/The_Teams_Group/SitePages/ProjectHome.aspx?csf=1&web=1&share=randomcharacters1234567890 

Then I shorten it to:

https : //ourcompanydomain . sharepoint . com/:u:/r/sites/The_Teams_Group/ 

Then it seems that I can get to the next step and PowerBI I get a prompt about which credentials / login do I want to use. I can choose between Anon, Windows or Microsoft Account. With the first 2 it says it can't authenticate with my details, but when trying to log in with Microsoft Account, it says "We are unable to connect because this credential type isn't supported for this resource". I'm not sure why is that, as in our company our windows account, microsoft account, sharepoint access etc. is all linked. I can easily access the Teams Group and the file I want to load into PowerBI through either Teams or Sharepoint directly. Moreover, I am already logged into PowerBI desktop with my PPU account.

What I also tried and which seems to work till some extent is to further modify the link like this:

https : //ourcompanydomain . sharepoint . com/sites/The_Teams_Group/ 

Then I again get a popup in PowerBI about the credentials I want to use and I manage to sign in with the Microsoft Account option. After that I get a popup about wheather I want to combine, transform or load the data. The problem here, however, is that when I choose the file I want to load from that teams group, it says "Pdf file failed to load with result: Corrupted". I don't know why would it say that, because 1) that is an xlsx not a pdf file; and 2) the file works well on Sharepoint or in Teams. It is not a huge file either with <1mb of size.

Any ideas of what I might be doing wrong or if it's just a bug would be appreciated.

Thanks!