cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
volodya
Frequent Visitor

Date change after update

After each server update, the date changes from the 1st day of the month to the last day of the previous month. If you upload the report to the server again, then everything is fine, but after the update everything crashes.
7 REPLIES 7
Dearc
Helper II
Helper II

Daily log, error still happen.

 

Dearc_0-1638320052628.png

 

Icey
Community Support
Community Support

Hi @volodya ,

 

What are you using? Power BI Service or Power BI Report Server?

 

It seams that you are using Power BI Service. If so, please consider Time Zone issue between local and Power BI Service.

 


Every Power BI Server (Where the Power BI Service lives) follows UTC (Coordinated Universal Time) for the server time. This is the universal time standard. You may have noticed that when you first publish your report the time stamp listed is correct it is only when you refresh that you see a difference. The reason for this is that Power BI refreshes time based on the localized time of the machine in which the report is refreshed on. So, refreshing on your local machine results in local time whereas refreshing on the services results in UTC.

 

Reference: Power BI Service Time Differences and How to Fix It


 

So you may do some operations to match the datetime between Power BI Desktop and Power BI Service. For details, please refer:

Avoiding Issues When Generating Time/Date in Power BI - 3Cloud LLC. (3cloudsolutions.com);

Resolving Timezone Issue on Power BI service – For Power BI.com (4pbi.com).

 

 

Best Regards,

Icey

 

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

Icey
Community Support
Community Support

Hi @volodya ,

 

Any updates?

 

 

Best Regards,

Icey

volodya
Frequent Visitor

Date in report data. There is a schedule for every 1st day of the month, and after the update, the date changes to the last day of the previous month.
Icey
Community Support
Community Support

Hi @volodya ,

 

What time do you set for scheduled refresh? Is the data in the data source updated completely before this time?

 

In addition, is the time zone of your data source the same as that on a computer hosting a report server?

Reference: Change Time Zones and Clock Settings on a Report Server - SQL Server Reporting Services (SSRS) | Mic...

 

 

Best Regards,

Icey

 

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

volodya
Frequent Visitor

Date in Report Data

FarhanAhmed
Super User
Super User

Which date we are talking about ?

 

Is it server system date?

Report Created/Modified Date?

Date in Report Data?

Schedule Refresh Date?

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!