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.

HomerW's avatar
HomerW
New Member
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,

  • Mauro89's avatar
    Mauro89
    Super User
    5 months ago

    Hi HomerW,

     

    thanks for sharing this insight. May I ask you which type of storage mode your semantic model is? Just out of curiousity and context. 

    Best regards!

    • HomerW's avatar
      HomerW
      New Member
      5 months ago

      Hi Mauro89,

      I'm very new to supporting this product and don't know all the terms yet. If your asking about our DB's we have many.  From SQL server to Oracle and many others. 

      Thanks,

      HW