Automatic refresh- Teams Excel File

[cpo6033]

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?  

[cpo6033 · Accepted solution]

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]

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]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic