Connecting to an excel file that is saved under shared file in teams

[liamcol]

Hi there, 

I am looking to connect to an excel file that is saved in teams files/sharepoint, but I can't find it when i click to get data from excel workbook. 

Has anyone done this before? 

Thanks 

[Icey · Accepted solution]

Hi @liamcol ,

We can find that when we share a file with others via teams, it will be stored in OneDrive by default. So if you want to connect to an excel file that is saved under shared file in teams, it is equivalent to connect to an excel file saved in OneDrive.

Then refer to the document @amitchandak mentioned and you can get what you want.

1. Open the excel file in Desktop App.

2. Copy path.

3. Connect to the file via Web connector in Power BI Desktop and delete "?web=1".

4. Authentication.

5. Click "Connect" and you will get what you want.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@liamcol , for SharePoint you have to get a link like, what is given in this document

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links