Forum Discussion

ania_roh's avatar
ania_roh
Icon for Helper III rankHelper III
3 years ago
Solved

No data about last refresh date in PowerBi Service

Hello,

I have a problem with showing data about the last refresh date in PowerBi Service.

In all reports that we have published in Service, we can see the date of the last refresh, like here:

 

 

But there is one report, that we can´t see that (the report is up to date and refreshes every day):

¿What could be the problem? 

Thank you 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ania_roh ,

    What is the connection mode of the report? 

     

    Only import model will show up the updated date. It means the dataset on power bi service has been updated at that date.

     

    Because when the dataset is Direct Query or Live connection model, the power bi does not refersh the report until user view the report or active with it.

    If DirectQuery and LC show up the updated date, it will be every time user open the report, becasue power bi service query the data sourece, not in power bi service, to get the underlying date and calculate the data for visuals.

     

    Please refer this article.

    Data refresh in Power BI - Power BI | Microsoft Learn

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • SwayamSinha's avatar
    SwayamSinha
    Icon for Microsoft Employee rankMicrosoft Employee

    I believe in case of the 2nd report 'Contenedores_SGA' the dataset refresh has failed. Can you check once?

    • ania_roh's avatar
      ania_roh
      Icon for Helper III rankHelper III

      No, it refreshed today at 9 and it has another refresh for tommorow, and the date is refreshed completely.

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ania_roh ,

    What is the connection mode of the report? 

     

    Only import model will show up the updated date. It means the dataset on power bi service has been updated at that date.

     

    Because when the dataset is Direct Query or Live connection model, the power bi does not refersh the report until user view the report or active with it.

    If DirectQuery and LC show up the updated date, it will be every time user open the report, becasue power bi service query the data sourece, not in power bi service, to get the underlying date and calculate the data for visuals.

     

    Please refer this article.

    Data refresh in Power BI - Power BI | Microsoft Learn

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi

    One user from my company experienced the same thing, the dataset uses import mode, it is successfully refreshed, but it doesn't show the last refresh date. Anyone has idea what it is the problem?