My dashboard and report don't refresh

[Anonymous]

I am new to Power BI and expecting your help.

I have scheduled to update my dataset from Google BigQuery at 7 AM every morning. I see the update successful.

But, my dashboard and report don't refresh according to the updated dataset. Fyi, the updates work fine in my desktop version.

Any thoughts?

[Anonymous]

HI @Anonymous ,

Actually, scheduled refresh is used to update your dataset. For report and dashboard refreshes, they are different than scheduled refresh and they will sync the latest dataset records report/dashboard side.

You can refer to the official document to know more about this:

Data refresh in Power BI 

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous 

Thank you for your comments.  After reading the link, I found the following phrase:

"Power BI maintains a cache for every tile visual on your dashboards and proactively updates the tile caches when data changes. In other words, tile refresh happens automatically following a data refresh. This is true for both, scheduled and on-demand refresh operations."

I feel like I'm lost. What should I do to set my dashboard automatically refreshed after its dataset is refreshed?

[Anonymous]

HI @Anonymous ,

I think you are misunderstanding with these descriptions, it only means tile refresh is a static refresh which triggers every 15 minutes. It will sync the latest data from the dataset to the cache of tiles even if the corresponding dataset not updated.

When you work on live mode(direct query, live connection), dataset refresh will also trigger the tile refresh.

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous 

thank you for your clarification. Then, do you mean the "import" connection I use for Google Big Query doesn't support dashboard refresh on a schedule basis?

[Anonymous]

HI @Anonymous ,

Scheduled refresh is work on dataset, it does not trigger report/dashboard refresh. For report and dashboard tiles, they will be updated automatically based on their refresh frequency. You can't do custom on refreshes of these contents.

Regards,

Xiaoxin Sheng

[Anonymous]

What about manually refreshing reports after dataset was refreshed?

[Anonymous]

If we use SQL server instead of Google BigQuery,

then can reports be refreshed right after dataset is refreshed?

[Anonymous]

HI @Anonymous,

Please take a look at the following scenarios:

Import mode
Dataset does not update: tile refresh will get data from the dataset.
Dataset updated: current tile data not changes, the next tile refresh will get the latest data from updated dataset.
live mode
Tile and report refresh and interaction with visual will trigger the dataset refresh and get the latest data from dataset.

Regards,

Xiaoxin Sheng