topic Re: Javascript code to refresh tiles inside dashboard only? in Report Server

Javascript code to refresh tiles inside dashboard only?

mpsrshl — Thu, 14 Jul 2022 04:33:52 GMT

Hey there,

Does anyone have some javascript code I can use in the way of a bookmark to make my dashboard's tiles refresh every 60 seconds?

This dashboard is set up as direct query.

I copied one that didn't work perhaps because it was intended for Power Bi Service tiles instead of on Premise.

Thanks!

Re: Javascript code to refresh tiles inside dashboard only?

v-luwang-msft — Mon, 18 Jul 2022 08:25:12 GMT

Hi mpsrshl ,

As it relates to development, I did not find a relevant article, you can refer to the following link and check if it is helpful to you:

https://community.powerbi.com/t5/Service/DirectQuery-Auto-Refresh-Dashboard-Every-60-Seconds/m-p/850412/highlight/true

Best Regards

Lucien

Re: Javascript code to refresh tiles inside dashboard only?

mpsrshl — Mon, 18 Jul 2022 20:11:53 GMT

Hi there,

thanks! after much digging on the web I found a script that works. I set it as a bookmark on the browser and save the url of it as this:

javascript&colon;function refreshPowerBI() {this.frames[0].postMessage({ kind: "powerbi.reportServerHost.IToolbarActionMessage", button: "refresh" }, "https://[your instance]/:443")} if (window.autoRefreshInterval) { clearInterval(window.autoRefreshInterval); };window.autoRefreshInterval = setInterval(refreshPowerBI, 30 * 1000)

I hope it helps other users.