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.
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.
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.