Dashboard/Report Refresh (after navigation)

[Anonymous]

Hi,

Currently we have dashboard (technically report) which takes 10-15 seconds to refresh. In the same Dashboard we have navigation to another page (tab) from Main Page. After navigating to another tab and it comes to home Page again, dashboard is refreshed again. And it take 10-15 seocnds again.

Do we have opton where it would be cache once so that it does not refresh again and again. Data is loaded only once a day. so it is required to refresh again.

Thank you in advance.

[v-xicai · Accepted solution]

Hi @Anonymous ,

To make dashboard tiles refresh, we need to have the dataset refreshed firstly. You can set schedule refresh for the dataset or manually refresh, see: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

After the dataset is refreshed, the dashboard tiles will be refreshed within 15 minutes. You can also force tile refresh by selecting Refresh dashboard tiles.

Dashboard refresh duration increases with the number of tiles. The tile refresh overhead can be significant. By default, Power BI maintains a single cache for every tile, but if you use dynamic security to restrict data access based on user roles, as covered in the article row-level security (RLS) with Power BI, then Power BI must maintain a cache for every role and every tile. The number of tile caches multiplies by the number of roles.

You can learn more: https://docs.microsoft.com/en-us/power-bi/refresh-data#tile-refresh .

Best Regards,

Amy

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

[Anonymous · Accepted solution]

Thank you so much for response.

[v-xicai · Accepted solution]

Hi @Anonymous ,

To make dashboard tiles refresh, we need to have the dataset refreshed firstly. You can set schedule refresh for the dataset or manually refresh, see: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

After the dataset is refreshed, the dashboard tiles will be refreshed within 15 minutes. You can also force tile refresh by selecting Refresh dashboard tiles.

Dashboard refresh duration increases with the number of tiles. The tile refresh overhead can be significant. By default, Power BI maintains a single cache for every tile, but if you use dynamic security to restrict data access based on user roles, as covered in the article row-level security (RLS) with Power BI, then Power BI must maintain a cache for every role and every tile. The number of tile caches multiplies by the number of roles.

You can learn more: https://docs.microsoft.com/en-us/power-bi/refresh-data#tile-refresh .

Best Regards,

Amy

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

[Anonymous]

That is exactly what I did, but my dashboard isn't refreshing.

I made reports with data imported from Google BigQuery, published them to the power bi service, and made the dashboard by pinning visuals. Then I set up a regular refresh schedule. I found the dataset is updated successfully, but my dashboard and reports are not.

Could you help me out?