Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh failed: Data Source ahas failed to refresh. Failure details: The last refresh attempt failed

Refresh failed: Data Source has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. 
This is usually a transient issue. If you try again later and still see this message, contact support.

Not a legal OleAut date.. The exception was raised by the IDataReader interface. Table: Active_patients.

Don't get me wrong, I'm grateful for the email notification, and I'm grateful for the indication of the reason for the error. But is it really because there's a date range before 1/1/1900? Or is there another possible reason?

 

If Power BI Service cannot handle dates prior to 1900, shouldn't this flag as an error during the Power BI Desktop report-building process? Especially because this is an Azure SQL Database source, so I am forced to use Power BI Desktop to build the report before setting it up for Scheduled Refresh.

Need Help

2 Replies

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    Anonymous 

    Can you please share the error details from the "Refresh History" by clciking on "Show Details".

     

    workspace >> Dataset >> Dataset Settings >> Refresh History >> Click the error (first one) >> show details >> click on copy.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Here is the error.

      I can confirm that there were multiple dates prior to 1900 and one date with the year 2900 in the dataset.

       

      Data source error:Not a legal OleAut date.. The exception was raised by the IDataReader interface. Table: test_patient.
      Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
      Activity ID: 
      Request ID: 
      Time:2019-10-28 09:10:14Z