daOnlyBG
daOnlyBG

Reputation: 601

PowerBI: One can schedule a data refresh, but how can one schedule a report publishing task?

Currently, I have a working dashboard in PowerBI with a data extract that needs to be refreshed several times a day; the visuals are embedded on a website. I need the data refreshes to reflect new data in the embedded visuals.

I know how to schedule a data refresh in PowerBI; assuming that the refresh completes successfully, how can I schedule the publishing of the dashboards?

I ask because although my data refreshes are working, the embedded visuals don't update until I manually publish each one through PowerBI.

Does anyone know how I can automate the second half of this process?

Upvotes: 1

Views: 1713

Answers (1)

NickyvV
NickyvV

Reputation: 1744

There are 4 types of refresh:

  1. Package refresh
  2. Model/data refresh (what you referred to as the first half of the process)
  3. Tile refresh (2nd half of the process)
  4. Visual container refresh

1 is not relevant for your scenario.
2 is handled by scheduling a refresh, it refreshes the dataset in the Power BI service as you mentioned.
3 is the update of the cache for tile visuals on the dashboard, once data changes. This happens (automatically) about every 15 minutes.
You can also force a tile refresh by selecting the ellipse (...) in the upper right of a dashboard and selecting Refresh dashboard tiles.

You

4 is used for refreshing the cached report visuals in a report, once the data changes.

You can take a look here for more info.

Upvotes: 1

Related Questions