Reply
Regular Visitor
Posts: 43
Registered: ‎04-14-2018
Accepted Solution

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:

 

1.png

 

2.JPG

 

3.png

 

 

If you can help me, I would be grateful.


Accepted Solutions
Advisor
Posts: 307
Registered: ‎01-16-2018

Re: Cannot updated or refresh reports and dashboards

[ Edited ]

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.

View solution in original post


All Replies
Member
Posts: 58
Registered: ‎03-07-2018

Re: Cannot updated or refresh reports and dashboards

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
Regular Visitor
Posts: 43
Registered: ‎04-14-2018

Re: Cannot updated or refresh reports and dashboards

@thanosdYes yes, by the way is working fine the gateway:

 

Capturar.JPG

 

 

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.

Advisor
Posts: 307
Registered: ‎01-16-2018

Re: Cannot updated or refresh reports and dashboards

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.

Regular Visitor
Posts: 43
Registered: ‎04-14-2018

Re: Cannot updated or refresh reports and dashboards

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.

Advisor
Posts: 307
Registered: ‎01-16-2018

Re: Cannot updated or refresh reports and dashboards

[ Edited ]

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.