cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akhaliq7
Helper III
Helper III

Data source errorNot a legal OleAut date.. The exception was raised by the IDataReader interface. Pl

In my power bi service I am getting an error while doing a data refresh. I checked other posts on the same issue and the solutions that were given were that it might be a date value such as with the year 1900 in your dataset. Now the problem is that how do i find such a value as i have 246 columns and 16000+ rows. Also i am able to get the data from power bi desktop just in power bi service i get this error. Is there a search facility or a automated way of getting the value that is out of bounds.

1 ACCEPTED SOLUTION
akhaliq7
Helper III
Helper III

Update: A even better solution I found to this problem was:

1. Select choose columns then unselect all columns.  

2. Type in date, (only works if date is in the column name). Select all the search result columns.

3.1.  Select column profile under view tab, find what columns you have the wrong values in should appear as the min value in column profile.

3.2. You can also sort ascending to a date column and remove nulls. This will show you all the year values that start with 0. If you work in a company need to take all the rows and give it to your senior team member. I copied the table and pasted the values to a excel file.

4. Take a note of the column(s) that have the wrong date value in e.g. 0202.

5. Clear above steps taken so far in applied steps,

6. Select Go to column, then type the column name,

7. Then use a date filter (after). I used after 01/01/1900 or equal to null

and that fixed my problem in minutes compared to the way i tried to fix it yesterday which took my a lot longer to fix

View solution in original post

1 REPLY 1
akhaliq7
Helper III
Helper III

Update: A even better solution I found to this problem was:

1. Select choose columns then unselect all columns.  

2. Type in date, (only works if date is in the column name). Select all the search result columns.

3.1.  Select column profile under view tab, find what columns you have the wrong values in should appear as the min value in column profile.

3.2. You can also sort ascending to a date column and remove nulls. This will show you all the year values that start with 0. If you work in a company need to take all the rows and give it to your senior team member. I copied the table and pasted the values to a excel file.

4. Take a note of the column(s) that have the wrong date value in e.g. 0202.

5. Clear above steps taken so far in applied steps,

6. Select Go to column, then type the column name,

7. Then use a date filter (after). I used after 01/01/1900 or equal to null

and that fixed my problem in minutes compared to the way i tried to fix it yesterday which took my a lot longer to fix

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors