Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Embedded iframe in webpage auto refresh interval not same with service defined interval

Hi,

 

I have a Power BI report, which gets data from a SQL Database Server through Direct Query. The dataset is scheduled to refresh every 15 minutes (in Power BI service).

The report is embedded in a webpage, through an iframe, for demo purposes. On the report, there is tile that shows the last refresh time.

The problem is that when the values are refreshed in Power Bi Service the respective embedded report is not refreshed, even if a user refreshes the whole page using the "refresh" button of the browser.

 

Is there a way to "sync" -if I am say it right- the embedded report with the original's report refresh time? 

Furthermore, is there a way to add a button labeled, e.g. "Refresh Now", which when pressed by the user refreshes the data?

 

Thanks in advance

3 Replies

  • you seem to be mixing up a number of concepts.

     

    Direct Query datasets do not need to have scheduled refreshes

    Reports do not have tiles, Reports have visuals.  Dashboards have tiles

     

    Are you looking at a report or a dashboard? If a report - did you set the auto page refresh parameter?

     

    Also note that "refresh"  has different meanings.  You can "refresh"  a dataset with old data as often as you want, it will still show old data.  Ideally your "refresh time"  should come from the actual data, not from the Power BI service.

    • Anonymous's avatar
      Anonymous
      Not applicable

      You are right.... I should put "tile" in quotation marks. In fact it's a shape with a measure inside...

      Of course, the auto refresh page parameter is active.

      My question was referring to the itnerval of the refresh between Power BI service and the respective embedded report. For example, in PBI service the "tile" shows 23:30 and in the embedded report time is half an hour earlier. I don't understand when it finally refreshes.

       

      • lbendlin's avatar
        lbendlin
        Super User

        Might be a timing issue ( pardon the pun) . Read about Shannon/Nyquist.

         

        Have you considered using a dashboard instead? It will update itself automatically each time the dataset refresh completes.