cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Dynamicaly update the tiles in a dashboard?

Is there a way the dynamically update the tiles in 'Dashboards' whenever the source in 'Reports' is updated?

Present solution looks more like a 'copy-paste values', and requires a lot of relabelling (tiltes) and repositioning to get what was previously created.

Any clue?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Dynamicaly update the tiles in a dashboard?

After updating to Power BI Pro, the issue completely disappeared. In other words, this was a limitation of the free version of PBI.

I will now consider this solved and advise those that may encounter a similar issue to consider either paying around US$120 yearly (good for one sharer and one collaborator) or use the free version if sharing is not your objective.

View solution in original post

17 REPLIES 17
Highlighted
Helper I
Helper I

Re: Dynamicaly update the tiles in a dashboard?

I am also wondering about this. It seems useless if when you update a report, the dashboard does not update as well. 

Highlighted
Memorable Member
Memorable Member

Re: Dynamicaly update the tiles in a dashboard?

When the data source refreshes, actually it should update also the dashboard..Sometimes needs a browser refresh due to cached data..If the tiles are not refreshing , there is a problem..Please provide some more details..

Also didn't understand about renaming titles etc..Guessing 1) if the dashboard is shared with you, any changes you made it will revert to the original version of the owner dashboard if refreshed..2) if you upload a pbix or excel file from onedrive and you change the reports it will also revert to the previous state every hour to reflect the stored file..

 

Not sure what applies to you..hope it helps

Konstantinos Ioannou
Highlighted
Helper III
Helper III

Re: Dynamicaly update the tiles in a dashboard?

@konstantinos thanks for the feedback.

Indeed the dashboards do not refresh with Chrome (is it browser related?), as for refreshing (not reloading right?) it sadly does not do the trick. Hence a modified tile within report previously pinned to dashboard does not dynamically update after refreshing the browser, even with disabled cache from devtool. Could MAC be the culprit here?

Since the tiles do not refresh, one has to resort to re-pin the visualizations and rename them (tedious work).

I am the author (owner) of said dashboards, I am merely testing the system before deployment.

Highlighted
Super User I
Super User I

Re: Dynamicaly update the tiles in a dashboard?

@Cyrilbrd You can dynamically refresh your dataset using REST API. Find the link given below for the webinar which we had conducted where we showcased how CRM Online can be connected to Power BI and refreshed in real-time.

Note: REST API session starts after 30 minutes 

Link: Power BI REST API using CRM Online as a Dataset

Highlighted
Memorable Member
Memorable Member

Re: Dynamicaly update the tiles in a dashboard?

@Cyrilbrd Not related to browser..What do you mean modified tile?..Edit report and change or filter the graph and then pin it?..Even if you save the report when the PowerBI fetch the data from OneDrive it will revert back to the old graph so the modified one won't be connected..( if I understand correct )

You can go to dataset and create new report with your modified tiles you need to pin..Logically this will be refreshed when the dataset ( manually refresh the pbix file in onedrive since you have on prem data sources & free account ) ..Of course you end up with two report pointing from one dataset..

 

Konstantinos Ioannou
Highlighted
Helper III
Helper III

Re: Dynamicaly update the tiles in a dashboard?

@ashishrj Thanks I will have a look.

@konstantinos Thanks, I found out that it just requires patience. The dashboards would update given sufficient time.

Still unsure about the trigger, as refreshing and clearing cache have no effect whatsoever.

Highlighted
Advocate I
Advocate I

Re: Dynamicaly update the tiles in a dashboard?

Cyrilbrd,

I understand AND AGREE ... once I build a report and pin it to a dashoard I would think the Report module would remain dynamic. However, if I edit that report - even by clicking from the dashboard - the report editing process actually makes a new report form while leaving the old format on the Dashboard. Intuitively, I would think that editing the report would update the "link" to that report state in the dashboard - replacing that version of the report in the dashboard. But, that is not the case.

Highlighted
Impactful Individual
Impactful Individual

Re: Dynamicaly update the tiles in a dashboard?

Agree. This is a limitation that needs to be addressed. There has to be an easier way to refresh a pinned dashboard that has had a filter applied (ie. Latest Month). Currently we have to delete, apply new filter, repin, and reorganise the dashboards.

 

The report owner should be able to repin and replace an existing component with whatever filter they have applied on the screen. Alternatively, each component in the dashboard could have its own filter as well.

Highlighted
Regular Visitor

Re: Dynamicaly update the tiles in a dashboard?

Has anyone had an updates on a fix for this issue? I haven't found any solid answers to this. I feel like there isn't a "link" between the report visualization and the one pinned to the dashboard. My specific issues is changing something on the visualization (not the dataset), saving the report, and refreshing the dashboard tiles, but it doesn't change the current visualization that is already on the dashboard. Any help would be greatly appreciated!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors