Forum Discussion

cpo6033's avatar
cpo6033
New Member
4 years ago
Solved

Automatic refresh- Teams Excel File

I have all of my excel files stored in my department's Teams site, and cannot move them out.  How do I import the excel files so I can set up a scheduled refresh?  
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • cpo6033's avatar
    cpo6033
    4 years ago

    Thank you! Unfortunately, that did not work.... I ended up having to clean up the link a bit (removing the /:x:/r after .com and anything after the .xlsx) and using the "web Sorce" data source option, the SharePoint one did not work for me for some reason...

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey cpo6033 ,

 

if you store a file in teams, it's technically stored in Sharepoint. You can see that when you open the file in Sharepoint:

 

Afterwards you can copy the link from the browser and load the file normally like any file from sharepoint.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey cpo6033 ,

 

I was wondering if it worked with the sharepoint link?

If my approach helped to make it work, I would be happy if you could mark it as solution ✔️. Like this, the next person who is stumbling across this post can see immediately what worked, without trying all the approaches for themselves.
 
If you need any help please let me know.
 
Best regards
Denis