cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexanderAT Regular Visitor
Regular Visitor

not a legal oleaut date - cannot refresh

Hello

 

I'm having a problem refreshing my report online. Everything works fine on the desktop version where I can easily update my dataset, but when uploading it and trying to refresh I get the following message:

 

Last refresh failed: 

Data source error:Not a legal OleAut date.. The exception was raised by the IDataReader interface. Table: ProfileScore.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:d9bc7478-5268-4bda-b634-728909e93f60
Request ID:8704eef6-6818-d9d5-fcad-ac50182d9685
Time:2018-10-11 09:27:47Z

 

I have read the other post with the same issue but those solutions do unfortunately not work for me.

Anyone know how to fix this error? 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
hansvanhoeij Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh

Hi there,

Dit you check the actual datevalues in your table? You most probably have a date before 1/1/1900 in one of the date fields in the table you're trying to load.

Kind regards,

Hans

7 REPLIES 7
hansvanhoeij Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh

Hi there,

Dit you check the actual datevalues in your table? You most probably have a date before 1/1/1900 in one of the date fields in the table you're trying to load.

Kind regards,

Hans

ICEPOC Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh

Just for those who got this problem also, as i did.

 

As stated above, i checked my data and found 1 entry with the year 0033. Once i corrected that problem, my data refreshed OK.

Zunair Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh


@ICEPOC wrote:

Just for those who got this problem also, as i did.

 

As stated above, i checked my data and found 1 entry with the year 0033. Once i corrected that problem, my data refreshed OK.


This should be added as a #bug and be marked as error in PBI desktop since PBI service can't handle it.

ICEPOC Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh

Maybe, but isnt the problem the underlying data rather than the app?


@Zunair wrote:

@ICEPOC wrote:

Just for those who got this problem also, as i did.

 

As stated above, i checked my data and found 1 entry with the year 0033. Once i corrected that problem, my data refreshed OK.


This should be added as a #bug and be marked as error in PBI desktop since PBI service can't handle it.


Maybe, but isnt it an issue with the data rather than the app?

Zunair Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh

Sure the data has a problem, but it should be caught in the desktop app before it gets caught in pbi service. Especially since pbi desktop suppose to show the errors in the new error check chart.
Highlighted
JPNOP Visitor
Visitor

Re: not a legal oleaut date - cannot refresh

Is there any way to convert dates before 1.1.1900 for the whole table? I have a bunch of tables with several columns including dates before 1.1.1900. Those dates come straight from ERP database and most of those cannot be changed in ERP GUI, (without manipulating the database). 

 

Maybe some power query string? Table.ReplaceValue ?

 

ICEPOC Frequent Visitor
Frequent Visitor

Re: not a legal oleaut date - cannot refresh

@JPNOP 

 

I would use switch for that:

https://docs.microsoft.com/en-us/dax/switch-function-dax

 

 

In that scenario you could simply replace any value before or on that date and then specify what you want as an output Smiley Happy

 

Hope that makes sense

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 427 members 4,523 guests
Please welcome our newest community members: