Power BI

Completed

Automatic refresh of dashboards

Vote (21)

Yiannis Antoniou on 15 Nov 2014 00:23:12

Need to be able to update dashboards with live data from Excel and other sources. This is already solved for PowerBI sites through automatic refresh using the DMG - the updated Excel file gets written to the PowerBi site, but this technique cannot be used here as there is no connection to Office 365. Either create a connection or create an equivalent mechanism for updating data (OneDrive alone is not enough).

Comments (22)

Comments (22)

Joshua Sherlock on 05 Jul 2020 22:51:05

RE: Automatic refresh of dashboards

This does not work with Live Pages thathave been pinned

Power BI User on 05 Jul 2020 22:28:00

RE: Automatic refresh of dashboards

i'm trying all day and definetely doesn't refresh. I have an Oracle data source with direct query. I pin entire report to the dashboard.

curtisp on 05 Jul 2020 22:27:42

RE: Automatic refresh of dashboards

"In order to have dashboard update automatically, the entire report must be pinned to the dashboard. If only a portion of a report is pinned to the dashboard, it will be static."

So the work flow should be:

1. Make report specifically for a dashboard tile eg just one chart, or KPI
2. Pin that entire report to the dashboard.

Then the dashboard tile will dynamically reflect data changes automatically.

However, I have portion of reports pinned to my dashboards, and while they are 'static' in terms of automatic refresh, after I update data source, I can refresh entire browser page to update 'static' pinned dashboard tile.

So automatic / dynamic refresh vs manual browser page refresh to get dashboard tiles to reflect data source changes.

Is this correct? Any other methods or features that can be used here to get dashboard tiles to reflect data source changes?

David Gelfuso on 05 Jul 2020 22:26:59

RE: Automatic refresh of dashboards

In order to have dashboard update automatically, the entire report must be pinned to the dashboard. If only a portion of a report is pinned to the dashboard, it will be static.

B Thakkar on 05 Jul 2020 22:26:22

RE: Automatic refresh of dashboards

Really is this fixed? As I still cannot refresh my dashboard tiles automatically as soon as my dataset get refresh on schedule. Data source is text file that is access through On-Premises Data Gateway.

Power BI User on 05 Jul 2020 22:25:05

RE: Automatic refresh of dashboards

I am using power bi embedded and publishing a report to a website and using page refresh every 5 minutes to make sure the report values are up to date.
Yet when the page refresh, the whole power bi active x seems to be refreshing causing to loose which report page you were viewing before the refresh and you get directed to the report default page.

Anybody have a better solution to keep report data live.