Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Report Server - Refresh data on embedded report

Hi -   Below, we have figured out the javascript code that can be pasted into the console to get a PowerBI Report Server report to refresh the data only (i.e. clicking the refresh button) on a time...
Embed
refresh data
Report Server
Anonymous's avatar
Anonymous
Not applicable
4 years ago

<iframe style="position: fixed; top: 0; left: 0; width: 100%; height: 100%; overflow: hidden;" frameborder=0 id="iframe" src="http://your-url:8080/Reports/powerbi/your-report:embed=true">
</iframe>
<script>
function refresh()
{
this.frames[0].frames[0].postMessage({kind:'powerbi.reportServerHost.IToolbarActionMessage',button:'refresh'},'*');
}
setInterval(refresh, 120000);
</script>
</html>

andyba's avatar
andyba
Regular Visitor
4 years ago

Hi Vincentt,

 

I'm trying to get this to work with the September 2021 release of the PBRS. However, I'm not able to get the report to refresh using the code as you've included in your example. I was very optimistic when I used the new Desktop for the Sept2021 PBRS that includes an automatic page refresh feature. However, it seems to only be valid for the Desktop and not when uploading to the PBRS. Unfortunately! And I do not understand why this feature is included only in the Desktop...

 

But back to the case: On which versions and configurations did you get this to work?

I'm very intersted learning how to come around this hurdle!

 

Thanks,

-A

  • MontherKH's avatar
    MontherKH
    Frequent Visitor
    2 years ago

    Have you figured it out?

    • andyba's avatar
      andyba
      Regular Visitor
      2 years ago

      Hi there,

       

      Unfortunately, not.

      We've moved away from using Power BI for such kind of dashboards for now. Some time ago, this refresh ability was added to the Desktop version for Report Server, however it did not work when deploying the dashboard to the server.

       

      I guess this will change with time, and actually, I've not tested the latest versions for an update on this.

      • MontherKH's avatar
        MontherKH
        Frequent Visitor
        2 years ago

        Could you tell me what other tool you used for this kind of dashboards instead of Power BI?

         

        Thanks.