Forum Discussion
Excel on Local Drive - Refresh
Am still a novice in PowerBi and currently evaluating it for a new company I work for. I have used it in a previous company and trying to recreate the same visualizations I did in my old job but runn...
Thank you for that explanation. I did just try it but getting a load error so nothing seems to be updating. I'll google the error and see if there's any help there. Now that I understand the process of going from PowerBi desktop to service it's actually a pretty good tool, just have to get passed the refresh hurdle.
v-juanli-msft
Community Support
Community SupportHi Anonymous
Since you use power bi desktop to create reports with excel on local drive and publish it to service, to avoid refreshing manually, you could install a on-premise gateway, then add the excel to the gateway and configure schedule refresh for the dataset.
Reference:
Best Regards
Maggie