Forum Discussion
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?
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...
3 Replies
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/DenSelimovicHey 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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
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...
