cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

View solution in original post

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.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

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