topic Re: Data refreshing error: Power BI service shows data until a specific date in Report Server

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

Anonymous — Thu, 11 Feb 2021 11:23:48 GMT

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!

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

Petebro — Thu, 11 Feb 2021 17:55:01 GMT

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?

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

Anonymous — Fri, 12 Feb 2021 08:08:03 GMT

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

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

Anonymous — Tue, 16 Feb 2021 14:18:45 GMT

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!