Get data from Excel Sheet kept in a sub folder in Teams

[FaisalImam]

Hi Team,

I am trying to load data from teams to Power BI.

When I am using the option Web - I am getting error  "Web.browsercontents currently support only anonymous credentials"

When I am using power Query Editor - geeting error Key did not found.

[v-easonf-msft · Accepted solution]

Hi, @FaisalImam 

It seems that you are current using Web connector.

You need to notice that  the new Web connector can't be used to connect to a source that requires non-anonymous authentication. 

Please review below threads for more details.

Web.BrowserContents currently supports only anonymous credentials 

Limitations on Web connector authentication for HTML content 

You can also try SharePoint folder connector  to connect to the files hosted on your SharePoint.

Best Regards,
Community Support Team _ Eason