Pulling data from MS Excel on Teams into Power BI

[adarshalok]

Hi Everyone, 

I  recently upgraded from Power BI Trail version to PRO. When connecting to the data source in the form of MS Excel maintained on Teams Channel, I'm unable to connect it. When connecting via source as 'SharePoint', it says the following error. 

When using 'Query' to add the link of Sharepoint, it's still the same. I cross checked for my role on Teams channel, I do have the Owner / Admin role as well. 

Can someone please let  me know how to overcome this obstacle. 

Thank you in advance. 

[lbendlin · Accepted solution]

When connecting via Sharepoint folder connector you need to specify only the Site/Team URL. Do not specify the complete path to the Excel file (you will use Power Query filters later for that)