Forum Discussion
Cannot updated or refresh reports and dashboards
I update a worksheet, save, and on powerbi.com when I click to refresh/update, doesn't work:
If you can help me, I would be grateful.
Hi danielsouza,
You can implement refresh programmatically using PowerShell - https://blog.gbrueckl.at/2017/08/refresh-powerbi-datasets-powershell-azure-runbooks/.
For instance, you can create Windows Schedule Task (time can be set to your needs, maybe 5-10 min) to run PowerShell script which can run dataset refresh in Power BI Service.
5 Replies
- Hi danielsouza,
If you first upload your report from a local file then you should have a gateway installed in order to be able to refresh the data.
See also this (https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-local-drive).
Hope this helps.
ThanosAnonymousYes yes, by the way is working fine the gateway:
But as I see I can only schedule the updates, so the updates are done, but take so long to appear on the reports and dashboards.
I would like to access the Power BI as service, without depending on the scheduled update, and click on the refresh button to see the updates.
Hi danielsouza,
You can store your report in OneDrive for Business and then connect to it from Power BI Service. See examples here - https://docs.microsoft.com/en-us/power-bi/service-connect-to-files-in-app-workspace-onedrive-for-business and https://www.techrepublic.com/blog/microsoft-office/how-to-harness-onedrive-to-keep-your-power-bi-dashboard-fresh/. As a result once you update Excel there your report will be refreshed automatically in Power BI Service.
