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

CorefocusHS's avatar
CorefocusHS
New Member
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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