Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
ninsights
Helper III
Helper III

How to refresh from Excel files stored in Teams

I have published a dashboard file (pbix) to the Power BI service. The pbix file points to Excel and CSV data files stored on Teams.
When I am in Power BI desktop, I can click refresh and it will suucessfully reach those files.

I would like to set up a scheduled auto-refresh in the Power BI service so I don't have to keep republishing the pbix file. The scheduled refresh fails on file credentials. I added credentials and each files shows a status of "online." I entered credentials in the Power BI service as OAUTH and privacy = ORGANIZATIONAL.

I do not have a gateway set up. I thought the files could be reached since they were on Teams. Do I need a gateway to make refreshing data from Excel files on Teams? Is it better if I store them on One Drive for Business?

Thank you for any assistance.


1 ACCEPTED SOLUTION
otravers
Community Champion
Community Champion

Behind the scenes Teams channels store files in SharePoint Online. There's no need for the data gateway nor to copy the files to OneDrive.

 

https://docs.microsoft.com/en-us/sharepoint/teams-connected-sites

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

2 REPLIES 2
otravers
Community Champion
Community Champion

Behind the scenes Teams channels store files in SharePoint Online. There's no need for the data gateway nor to copy the files to OneDrive.

 

https://docs.microsoft.com/en-us/sharepoint/teams-connected-sites

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals
blopez11
Super User
Super User

How did you ingest the files into Power BI?

If you open your Teams site in SharePoint, you can follow the instructions below for loading files from OneDrive, then once you publish to the service, you should be able to schedule your refresh (all without a gateway)

blopez11_0-1656011977338.png

 

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

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors