0

I'm using direct query mode between sql server database and Tabular project analysis services on one side and between analysis services and POWER BI on the other hand. when I filter by date in POWER BI analysis services convert the date into this format yyyy-mm-dd hh:mm:ss and SQL server answer with error:

Converting a varchar data type to a datetime datatype create a value out of range.

Any idea?

scopchanov
  • 7,966
  • 10
  • 40
  • 68
Ghada
  • 1
  • Do you have an example of the varchar data that is failing to convert? – userfl89 Sep 19 '18 at 15:05
  • i don't understand why the direct query engine convert a date to a datetime format like that: date = CASt(N'2018-07-23 00:00:00' as datetime) ? – Ghada Sep 19 '18 at 15:22
  • Duplicate of https://stackoverflow.com/questions/20838344/sql-the-conversion-of-a-varchar-data-type-to-a-datetime-data-type-resulted-in – CR241 Sep 19 '18 at 19:53
  • Possible duplicate of [SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value](https://stackoverflow.com/questions/20838344/sql-the-conversion-of-a-varchar-data-type-to-a-datetime-data-type-resulted-in) – CR241 Sep 19 '18 at 19:54
  • i can't change the request, it is sent by the tabular ssas model – Ghada Sep 20 '18 at 12:09

0 Answers0