Forum Discussion

lewand03's avatar
lewand03
Helper I
9 years ago
Solved

Dashboards are not refreshing

HI All,   After publishing my report to WEB and refreshing data then the "WEB" version still remains the same. I found some posts with advises: 1. to add &refresh=5 parameter, 2. repin dashboard...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi lewand03,

     

    From this official document, data refreshes are automatically reflected in your embedded report or visual. It can take approximately 1 hour for refreshed data to be visible from embed codes. If your dataset contains large amout of data rows, it might spend long time updating.

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi lewand03,

 

What did you mean dashboard in above post? 

 

Based on my understanding, you came across the problem that the report published to web didn't update data, right? Is there any slicer in your report? If you refresh the web page manually, will the report show latest data? You said "some graphs are still showing old data", how did you create those graphs?

 

Regards,
Yuliana Gu

  • lewand03's avatar
    lewand03
    Helper I
    9 years ago

    Hi Yuliana,

     

    By Dashboard I mean report published on WEB (From Report View: File->Publish to WEB). Pinned report as dashboard is working fine however there is no drill down functionality so I cannot use it.

    Yes, I have slicer with time restriction done on a oage level filter. The restrinction is done base on Time dimention:

     

    Last 365 days = if(AND('DIM Date'[Date Range]<=TODAY(),'DIM Date'[Date Range]>=(TODAY() - 365)), "YES", "NO")

     

    And filter is Last 365 selected as YES.

     

    Graphs are also time based (same dimension as slicer).

    Additionally I have couple of "KPI" brics which are showing information from current day

    Today = if('DIM Date'[Date Range]=TODAY(),"YES","NO")

     

    and yesterday when I was testing my report (WEB version) after couple of hours graph was showing proper data (KPIs still data from day before yesterday) and today morning the whole report is showing data from yesterday correctly.

     

    It seems that refreshing WEB version of this report takes quite a long (more than couple of hours) even with parameter refresh...

     

    Any advice?

     

    Regards,

    Dariusz

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi lewand03,

       

      From this official document, data refreshes are automatically reflected in your embedded report or visual. It can take approximately 1 hour for refreshed data to be visible from embed codes. If your dataset contains large amout of data rows, it might spend long time updating.

       

      Regards,
      Yuliana Gu