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

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 I
Helper I

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 I
Helper I

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!