cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielsouza Regular Visitor
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
zoloturu
Advisor

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

5 REPLIES 5
thanosd Member
Member

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
danielsouza Regular Visitor
Regular Visitor

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.

zoloturu
Advisor

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.

danielsouza Regular Visitor
Regular Visitor

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.

zoloturu
Advisor

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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 159 members 2,028 guests
Please welcome our newest community members: