cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gesgin
Helper I
Helper I

Date format problem after scheduled refresh

Hi,

 

The date format that I'm using on Power BI Desktop development is DDMMYYYY. Date format of the server that report server was installed is also DDMMYYYY. After I deploy the report to report server, there's no problem. However, after scheduled refresf, on a particular part of the report, the date format is recognised as MMDDYYYY, so I see 1 October as 10 January. How can I fix that problem?

 

Thank you

1 ACCEPTED SOLUTION

Hi,

 

It seems it's not a browser problem. We found another solution and it works fine for now.

 

Thank you

View solution in original post

4 REPLIES 4
gchris05
Regular Visitor

I had the same problem, but the browser settings didn't solve it. In the end, I manage to solve it by changing the locale of the "Date" field using the power query.
Steps:
1. Select the table with the date field
2. Navigate to Table tools (on the ribbon)
3. Select Transform data (The power query will open)
4. Navigate to the table with the date field and right-click on it
5. Select "Change Type" then "Using Locale" change data type to date and select the Locale you wish
6. Enjoy 

 

v-qiuyu-msft
Community Support
Community Support

Hi @gesgin,

 

Did you use the same browser on the same machine to view the report before and after schedule refresh? 

 

Please try to run the latest Power BI report server version. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

It seems it's not a browser problem. We found another solution and it works fine for now.

 

Thank you

View solution in original post

Hello! Can you share your solution? I'm having the same problem.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps