Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data refreshing error: Power BI service shows data until a specific date

Hello Dear community,

 

I have a Power BI report configured to show the last value,  connected to an Oracle Data Base that stores new data each 30 minutes. On Power BI Desktop, I am able to obtain and show that last value with no issues: 

 

 

However, in Power BI server, the reports always shows the data of an specific day and date (12  January at 11:30 pm):

 

 

I set up data refresh each 30 min and there seems to be no issue with that (Gateway is good to go and I am getting no errors when refresh occurs).   I have tried deleting and re-uploading the report, deleting the gateway and manually refreshing the report from in the app but it seems not working.

 

Has anybody encountered this issue? Have you any advice or solution ?

 

Thank you in advance for your help! Cheers! 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello, issue solved: 

     

    It was apparently an issue between both Power Bi desktop and web browser language and time format.

     

    I just changed the PBI report to match browser's language.

     

    Thanks for your help! 

3 Replies

  • Petebro's avatar
    Petebro
    Microsoft Employee

    The refresh is successful in the server? Do you have the logs from the server when the refresh happens that you could share?

     

    Also I assume you refresh the browser as well after the refresh happens to fetch the new model?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello, thanks for your answer. I'm attaching the server refresh logs: 

       

       

      yes, I do refresh the broswer after update. I have also clear the broswe history. 

       

      I'm guessing there has to be some issue related to the date, I'll try to change the date type of my data. Is it possible that the on-premises server date and the report dates are in conflict? 

       

      thanks again for your time 

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hello, issue solved: 

         

        It was apparently an issue between both Power Bi desktop and web browser language and time format.

         

        I just changed the PBI report to match browser's language.

         

        Thanks for your help!