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