Forum Discussion
Post PartisanUser refresh on PBI Service
Most Valuable ProfessionalIf you schedule refresh on the reports in the service, they will run even if you are not around. If you want to future-proof it, have a service account take over the dataset/scheduled refresh (that way it's not linked to your account at all).
When a different person opens a PBIX, it'll trigger them to re-authenticate on all the sources, so it's really better to just schedule the refresh (SharePoint totally supports scheduled refresh).
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
yaman123I should have mentioned that scheduled refresh is on. I have to manually add an image to the report each week hence why I need to refresh the report manually on desktop.
- christinepayton
Have you considered dynamically pulling in the images? You could upload them to a SharePoint folder and use that as a query and display it that way, so that the only thing you'd need to do is upload the file and it'd automatically show up in the report after the scheduled refresh.
The only weirdness with this is that the images do not show up in the desktop app at all, only in the service (it's a weird auth thing).
If you still want to refresh in the desktop each time, you would need to give the person refreshing access to the source (or use a service account).
- yaman123
Currently I receive an image each week and I replace the image in the report. If the user was to go back and check the history, this cant be done as the image is the latest one. Is there a way for an image to be dynamically updated in the report as I need the Week Commencing field and the image for that week. I did think about creating an excel file with 2 columns - wc and image but dont think this can be done. I am open to any solutions you have?