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!