Forum Discussion
Cannot updated or refresh reports and dashboards
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.
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.
Thanos
AnonymousYes 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.
Dear zoloturu, thanks for showing me this option.
I'm trying to introduce in several customers the BI concept, so I have to use the maximum free benefits I can, as I see one drive is paid.
I just want to update some data in a local Excel worksheet, and then, manually refresh and I see the data online.
