Forum Discussion

AnSchmi's avatar
AnSchmi
Icon for Helper II rankHelper II
4 years ago

Saving datamart fails

Dear Team, 

I'm not able to save any queries from dataflows they contain a date field. 

While saving following meassage appears 

Wrapping things up

InternalError
ErrorMessageString was not recognized as a valid DateTime.HttpStatusCode500
 
Has someone any idea ? 
Thanks a lot for your help in advance
Best Regards
Andreas
 
dataflow
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AnSchmi ,

     

    1. What date format (yyyy/mm/dd) are you using? Check the data format of the date field, if it is "Any", please change the field format to the appropriate one. Check the query for the conversion format step.

     

    2. Please try removing the expression and adding it again.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

    • AnSchmi's avatar
      AnSchmi
      Icon for Helper II rankHelper II
      4 years ago

      Dear Gao, 
      the data format of the dates in all my dataflow are "Date".
      Importing the dataflow to desktop and service works fine. 

      The import of the dataflow with the correct date fields are working as well. 

      Only saving the query is not possible. 

       

      The quere in the datamart after importing is

       

      Meanwhile I tried to import an Excel file from Share Point. 

      It does not work either. Following message

       

      It seems to me all the problems are related to settings of 

      languages and countries/regions ? 

      What do you think. 

      Thanks a lot for your help. 

      Best Regards

      Andreas