Forum Discussion

HomerW's avatar
HomerW
New Member
5 months ago
Solved

Current Date will not update

BI is refreshing daily, but will not load new content to the dashboard through the Power BI online service. If we refresh the corresponding dashboard on our computer through desktop, it works. Thi...
Real-Time Dashboard
  • HomerW's avatar
    HomerW
    5 months ago

    Hi v-priyankata,

     

    We did figure out the issue. Its not anything to do with the measure; we could see the last date in our data in the downloaded dashboard. Since you have to download the dashboard to see this we add the lastdate measure to everything to evaluate data is current.

    What turned out to be the issue was that this option, in Power Query editor, was not selected:

    Thanks,

v-priyankata's avatar
v-priyankata
Community Support
5 months ago

Hi HomerW 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

The measure uses (LASTDATE('!SIR'[DATE]), which depends on the report’s filter context. In Power BI Service, dashboard tiles can sometimes keep a cached result even after the dataset refresh finishes. Because of this, the dashboard may still show the older date. When you refresh the report in Power BI Desktop, the model recalculates immediately and returns the latest date from the table, so it updates correctly.

 

First, confirm that the dataset refresh in Power BI Service completed successfully. If the dashboard still shows the old value, refresh or repin the dashboard tile so it pulls the latest data from the refreshed dataset. Repinning forces the tile to query the dataset again and display the updated result from the LASTDATE measure.

 

If there are any deviations from your expectation please let us know we are happy to address. 

Thanks.