Forum Discussion

gesgin's avatar
gesgin
Helper I
8 years ago
Solved

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 se...
date format
scheduled refresh
  • gesgin's avatar
    gesgin
    8 years ago

    Hi,

     

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

     

    Thank you

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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