Forum Discussion

GK600's avatar
GK600
Helper II
5 years ago

Date Format Error

Hi,   Hope someone can help me. I have looked through many forums but didn't come across this one.   My regional settings is English (United Kingdom) and Data load type detection is set to below....
GK600's avatar
GK600
Helper II
5 years ago

Thanks Greg_Deckler  for your repsonse.

 

I actually don't need date to convert into UK format. I want it to stick to US format (that's how it appears but with "text" as data type when loaded into Power BI). The moment, I change the data type to "Date", it starts to cause issues. 

 

I anyway tried as you suggested but strangely when I changed it to "Date" as Data type, it converts it into UK format (I also tried using locale). Please see below. This is quite weird as I do have US as regional setting for this file. Not sure why its pushing it to UK format. 

 

 

Any pointer will be helpful.

 

regards,

Gaurav

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

GK600 - What are your regional settings File | Options and settings | Options | GLOBAL | Regional settings and also CURRENT FILE | Regional Settings. Also check if Model language has been set.

 

  • GK600's avatar
    GK600
    Helper II
    5 years ago

    Greg_Deckler  

     

    Thanks for your quick response.

     

    Please see below. Model language shows "Use Application Language". 

     

     

    Find below the regional settings but I tried to change it to US as well but it still converts to UK date format. (I also used "Use locale" to set the date type etc. but didnt help)

     

     

    Hope this helps to review the problem.

     

     Gaurav

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      @GK600- Well, my concern is that the model language was established in the UK when the report was created and if that's true, you can't reset it in Power BI (maybe the tabular editor) and that may be the problem you're having.

      You can check out the Problems forum here:

      https://community.powerbi.com/t5/Issues/idb-p/Issues

      And if it's not there, then you could publish it.

      If you have a Pro account, you can try opening a support ticket. If you have a Pro account it's free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

      • GK600's avatar
        GK600
        Helper II
        5 years ago

        Thanks a lot Greg_Deckler ,

         

        If that’s an actual issue, it’s surely worth raising. I will take a look and raise it if needed.

         

        By the way, do you mind looking at my quick question above re possibility of being able to reduce size of excel sheets. That would be great help as transformation of data is taking good amount of time.

         

        Regards,

        Gaurav

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi GK600 ,

       

      In Power BI you have set your Regional Settings to pick up the Windows setting Regional information by default.

       

      Go to your windows machine Regional Settings and modify there US timezone:

       

       

      Thanks,

      Pragati