Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Automatically Update Data on Teams without Re-Publish from Desktop

Hello Forum,


This is a great forum I have got so many answers out of it which saved my life! So I just thought I would go ahead and ask something that has been troubling me for about 2 weeks.


My situation, I have an excel spreadsheet in Teams, which I managed to link to a Desktop Power BI report. I have also published this report on service for everyone to see. 


The reason the excel file (dataset) is on Teams is so everyone can update the file and theoritically be able to view the updated dashboard online. Unfortunately whenever an update is made to the excel file, the only way to get the service report to refresh is to :


1. Open the desktop version and refresh

2. Re-publish the report and wait 20-30 minutes.


Is there any way that I can immediately get the results to refresh on service without needing to open the desktop version? As the desktop version is currently on my laptop locally and whenever someone makes a change they need to message me being like "Please refresh and republish the file". Which doesn't seem very efficient. 


Thank you in advance!

New Member

This might be different from the actual mentioned problem in above. But i am having difficulties on auto refresh reports which made from a Sharepoint online list,  published on Microsoft teams. What i can see is, the Power BI online application updates the report automatically once the list item updated. But, if i open the report on Power BI desktop application it doesn't reflects the updated list data.


Is there any way out to get the updated reports while sharepoint online list items getting updated without opening the Power BI desktop application and update the reports once again manually and republish it to my teams workspace?


Please help !

Community Champion
Community Champion

Hi, have you tried putting your excel on a folder then import it to power bi via folder and not via excel?




It worked on my side.

Community Support
Community Support

HI @Anonymous ,

How did you publish your report? Can you please explain more about these steps?

How to Get Your Question Answered Quickly

In addition. I'd like to suggest you take a look at following link to know more about how to configure scheduled refresh: Configuring scheduled refresh


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Not applicable

Hello Xiaoxin,


Thank you for getting back to me and sharing the links.  


I have followed the following steps:


1. Uploaded the excel spreadsheet on Microsoft Teams

2. Connected to Teams from power BI desktop using "Get Data" following this post

3. Built my dashboard on desktop version

4. Published using the publish button on Power BI Desktop and chose "My Workspace" as the place to publish


Hope this makes sense , I apologise if I am missing a point here. I have also scheduled a refresh using a similar method to the one described on the link you shared, however it still won't update online unless I refresh the desktop version and republish it. 


Thank you again for your reply.


Kind Regards,



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors