Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

6 REPLIES 6
CorefocusHS
New Member

I have the same issue, what did you do to fix it?

For me my data is fine in the Windows PowerBI Editor and also looks good right after I publish it to the web. However after I refresh the dataset to get the latest information the dates I set to use locale revert back with no explanation why.

Please find my comment post below:

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 

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

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.