cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
liamcol
Helper I
Helper I

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

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 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @liamcol ,

 

Icey_0-1632290868187.png

 

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.

Icey_2-1632291643170.png

 

2. Copy path.

Icey_3-1632291878334.png

 

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

 

Icey_1-1632291403622.png

 

4. Authentication.

access.PNG

 

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

Icey_4-1632292059653.png

 

 

Best regards

Icey

 

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

 

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @liamcol ,

 

Icey_0-1632290868187.png

 

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.

Icey_2-1632291643170.png

 

2. Copy path.

Icey_3-1632291878334.png

 

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

 

Icey_1-1632291403622.png

 

4. Authentication.

access.PNG

 

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

Icey_4-1632292059653.png

 

 

Best regards

Icey

 

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

 

View solution in original post

amitchandak
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.