I want to correct the difference in the dates on the first and second pages.

[Tome_05]

I am always grateful for your help.

There are some things I don't understand when automatically updating BI, so if anyone knows, please let me know.

There are two attached images, one page and two pages each.
The date written in the red circle on the first page is the 22nd, but on the second page it is the 23rd.

The queries on the first and second pages use the same query, but when I check the automatic update, the date on the first page cannot be updated properly.

If anyone knows how to solve this please let me know.

thank you.

[Anonymous · Accepted solution]

Hi, @Tome_05 

Power BI might set the display date based on the time zone of the data source or the Power BI service itself. Make sure that both pages interpret the date data in the same time zone. You can check the following link:

Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn

You can also validate the date format, which can be different for visualizations applied to each page, resulting in different dates. Make sure that the date format is consistent throughout the report. You can check the following link:

Format numbers and dates in Power BI paginated reports - Power BI | Microsoft Learn

Although the queries are the same, it's worth double-checking the underlying data model and any transformations applied to the date field. Make sure that no additional steps or filters are applied to one page, and the other page may not exist. This includes verifying that both queries are indeed fetching and processing data in the same way.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[_AAndrade]

Hi @Tome_05;

Could you share a pbix so I can take a look?

[Tome_05]

I get the message "The file type (.pbix) is not supported." and cannot send pbix.

[_AAndrade]

Hi @Tome_05,

I've tried to simulate your issue but when I update the report on the desktop app the dates on both pages are the same as you can see in the images below:

Page 1

Page 2