Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Datetime2 is not a defined system type

I have a report developed that is attached to a dashboard.  I use a SQL database as the source of my report.  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.  Anyone have suggestions?

Thanks in advance.

 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    Please check if the data type is valid in SQL Server and same with that in power bi.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      My data is being pulled from just one table.  The table is in SQL Server Express Edition, Version 9.4.5000.00.  I pull the data straight into Power BI.  From the Query Editor I changed all of the columns I am using from DateTime format to Date MM/DD/YYYY to facilitate date range comparisons.  When I run the Refresh from within the Desktop environment it works great.  I have confirmed my row counts and hash level totals and they are correct.  It is the published version of the report, that is part of a dashboard, that will not successfully refresh.  I am using a Corporate Gateway that works successfully for my other reports.  

      When I navigate to the Power BI site and manage Gateways I can select my defined part of the cluster and the Data Source Settings Tab reflects the connection is successful.  I am using Organizational level Privacy.  

      I am at a loss on how to proceed.  Any further advice?