Cannot updated or refresh reports and dashboards

[danielsouza]

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.

[Anonymous]

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.

Thanos

[danielsouza]

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

[zoloturu]

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-bus... and https://www.techrepublic.com/blog/microsoft-office/how-to-harness-onedrive-to-keep-your-power-bi-das.... As a result once you update Excel there your report will be refreshed automatically in Power BI Service.

[danielsouza]

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.

[zoloturu · Accepted solution]

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.