cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Not a legal OleAut date..

I cannot thank you all enough...was tearing my hair apart 

 

Didnt understand why query would run on sql , refresh locally and then fail in the gateway

 

it was indeed dates

 

 

Thanks again

 

 

Evgeniy_A Occasional Visitor
Occasional Visitor

Re: Not a legal OleAut date..

Solution:

I had the same issue 

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

In my case the issue of updating data set was:


in one table with Customers data we had birthday date - in date format obviously.

some of dates were incorrectly filled with data earlier than 1/1/1900 (for example "1/30/0992"

after filtration of the filed issue disapired.


looks like it some data filed parameter - which doesnot read that type of dates.
hope that helps

Highlighted
muneern Frequent Visitor
Frequent Visitor

Re: Not a legal OleAut date..

Hi All,

 

I had the same problem -- but wasnt able to easily identify the root cause, since there were many dates that were at extreme ends of the range (e.g. Year 0001 or year 9999)

 

This is what I did to fix it:

  1. Added a custom column in the with the following formula:
    NewColumn = Number.From([Due Date])
  2. Convert custom column to decimal number
  3. Sort the table by this column

 

This then gave the following error, which I could use to identify the problematic records in the table:

 

Date Error.png

 

I hope this helps someone else.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors