Time Intelligence - Date format changing every time the report refreshes

Hi SahityaYeruband 

Thanks for the reply from uzuntasgokberk .

SahityaYeruband, did you create the report in Power BI Desktop RS and then upload it to Power BI Report Server? If so, you can also try the following:

Do the following in Power Query.

In the Locale option select a locale that displays dates in day/month/year format.

Power BI reads dates according to the date format of the region. Since the month will not exceed 12, Power BI will recognize that 24 is date rather than month. However, for 11, Power BI will automatically read the data according to the date format of your region. If the format of your region is month, day, and year, Power BI will read the date according to the month, day, and year, and then display it according to the "dd/mm/yyyy" you set.

The above method forces Power BI to read the date in a day/month/year format.

Output in Report Server after refresh:

Best Regards,
Yulia Xu

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