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.

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

  • ryans's avatar
    ryans
    Helper I
    10 years ago

    tristanstcyr I am still having this issue. Any update?

    • tristanstcyr's avatar
      tristanstcyr
      Helper I
      10 years ago

      Hi Ryan,

       

      I'm sorry this is still not working for you. Let me loop in the engineer who worked on this...

       

      Tristan

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I am having the same issue as the user from 2016.

        I have a report developed that is attached to a dashboard.  I use a SQL database as the source of my report.  The version is SQL Server Express Edition 9.4.5000.00 and it is the backend of an IT ticketing system.  I am able to pull data, publish and refresh from the Desktop.  I have scheduled the dataset to refresh.  The scheduled refresh will not complete on the scheduler and I cannot make it refresh.

        I get Underlying error code -2147467259 Table:TASKS

        Underlying error message Microsoft SQL: Type datetime2 is not a defined system type

        DM_ErrorDetailNameCode_UnderlyingHResult -2147467259

        Microsoft.Data.Mashup.ValueError.Reason DataSource.Error

        Cluster URI WABI-US-EAST2-redirect.analysis.windows.net

        I have the most current version of desktop loaded.  When I googled the error it looks like something that existed back in 2016 that is supposed to be fixed now. 

        I did not see a solution marked for this issue.  Recommendation(s)?