Forum Discussion

AlexanderAT's avatar
AlexanderAT
Icon for Helper I rankHelper I
8 years ago
Solved

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 fo...
Error updating
Help me please
Refresh
  • hansvanhoeij's avatar
    hansvanhoeij
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Zunair
Icon for Advocate II rankAdvocate II
7 years ago
Anonymous 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.

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

    Zunair wrote:
    Anonymous 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's avatar
      Zunair
      Icon for Advocate II rankAdvocate II
      7 years ago
      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.
      • hansei's avatar
        hansei
        Icon for Helper V rankHelper V
        7 years ago

        I agree wholeheartedly with Zunair . If the data is unacceptable in service, the desktop app should flag/warn/prohibit. At the same time, it would be preferable if it simply accepted valid dates.