Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
danielsouza
Helper III
Helper III

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

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
Anonymous
Not applicable

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

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

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.

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors