Dashboard tiles using live connection not updating

[Anonymous]

Dashboard tiles from datasets that use live connection to multi dimensional cubes are not updating.

The dataset is has a scheduled cache refresh set to 60 minutes. the underying cube is reporocessed every 90 minutes.

Ex:

Report Refresh Schedule

This report is using an Import Connection.

This report is set to refresh automatically a t the following times everyday

5:00AM EST

11:00AM EST

3:00PM EST

5:30PM EST

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

If you mean you change the visualization type on report, but the dashboard doesn't reflect, this is a limitation.

See more here: Considerations and troubleshooting

• If the original visualization used to create the tile changes, the tile doesn't change. For example, if you pin a line chart from a report and then you change the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type does not.

If you mean the data on the dashboard doesn't refresh along with report and dataset.

In this scenario, I think you just need to configure the a schedule refresh on your dataset. And you just need to update data at your data source side.

For Dashboard Tiles, we have tile refresh which occurs every 15 minutes. For more details, please see: Data refresh in Power BI

If you are using the On-Premise Gateway and have it refeshing via a schedule your Dashboard tiles will update automatically after the scheduled refresh.

see more here: Configure scheduled refresh

For more information, you could refer to:

Troubleshooting tile errors

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Is there any update or other way we can do this without our users having to manually click the tiles to have them be refreshed?

[Anand24]

@Anonymous ,

Its still the same. Users will have to click on the tile to navigate towards refreshed report.

A work-around that sometimes work is have a complete report pinned to the dashboard. So you can create a page with just the 1 visualization you require and then pin it to dashboard.

Try this, maybe it would work.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anonymous]

Hi Stephen,

Thank you for responding so quickly on this. The solutions you have posed are not applicable to the issue that we are having, so I apologize for not being more clear on this. Our issue is more related to Dashboard tiles using live connection updating. 

The scheduled cache refresh is configured but the tiles aren't updating unless the users Manually clicks the 'Refresh' icon

[GilbertQ]

Hi @Anonymous 

The dashboard cache refresh from a LiveConnection will update on the schedule defined. I have seen it working in the past where it depends on how long it takes for the queries to be executed to the underlying SSAS model.

Also make sure that you do not have a proxy server which could cache the Power BI Dashboard tiles.