Forum Discussion

ryans's avatar
ryans
Helper I
10 years ago
Solved

Datetime2 is not a defined system type

Hello All,   I am having some issues with filtering a column by dates when connecting to SQL Server 2005. Whenever I try to filter by dates in the query editor >= 01/01/2015 I get an error:   Dat...
Need Help
  • tristanstcyr's avatar
    tristanstcyr
    10 years ago

    We fixed this internally this month. You can expect a fix for this in the March release.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Do you have any control over the database you're connecting to? If so you could look into adding a view on top of the data source and converting the date into text or an integer (or joining to a date dimension) and filtering on that instead.

ryans's avatar
ryans
Helper I
10 years ago

Unfortunately, no control. Thats a good idea joining it to a date table then I could filter by the values for year and business period.

  • tristanstcyr's avatar
    tristanstcyr
    Helper I
    10 years ago

    We fixed this internally this month. You can expect a fix for this in the March release.

    • ryans's avatar
      ryans
      Helper I
      10 years ago

      tristanstcyr That is awesome! Will make my life a lot easier.

    • averied's avatar
      averied
      New Member
      10 years ago

      Was this fix already release?

       

      I've got the same error when filtering a SQL 2005 date on Power Bi desktop version 2.34.4372.322 64-bit (abril de 2016)

      • Rasmusrock's avatar
        Rasmusrock
        Helper II
        10 years ago

        I have also just run into this error. Has it been fixed already? or is there a simple way to solve it?

         

        Thanks in advance,

         

        /Rasmus