Forum Discussion

GK600's avatar
GK600
Icon for Helper II rankHelper II
6 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....
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 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
Icon for Helper II rankHelper II
6 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
    Icon for Community Champion rankCommunity Champion
    6 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
      Icon for Helper II rankHelper II
      6 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

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        6 years ago

        GK600 - Well, so I guess the first question to ask is if these are all the same format and you are using a Folder query with combine binaries essentially and all the information essentially goes into a single table? That would be optimal since this would maximize the columnar compression of the Vertipaq engine. 

         

        Second, turn off the auto-date hierarchy here and refresh (uncheck). Let me know results but this can reduce model size by up to 60% or so:

         

         

         

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      4 years ago

      DataSource.Error: Microsoft Informix Client: Date could not be converted to month/day/year format SQLSTATE=IX000 SQLCODE=-1210 Details: DataSourceKind=Informix DataSourcePath=10.11.0.311:9089;pbase Message=Date could not be converted to month/day/year format SQLSTATE=IX000 SQLCODE=-1210 ErrorCode=0

      I changed the regional settings to Englist(United Kingdom) and (United States) but the problem persit.

      In both tables de column date have the format mm/dd/yyyy.

      arolhaiser_0-1646842025492.png

      arolhaiser_1-1646842025463.png

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 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