Forum Discussion

Buzz123's avatar
Buzz123
Advocate I
8 years ago

Date issues with Sharepoint file sources

The March update (2.56.5023.861 64-bit) got installed this morning.  Unfortunately, it's broken the ability for the Power BI Desktop Query to understand dates from a sharepoint folder source.  This f...
Buzz123's avatar
Buzz123
Advocate I
8 years ago

When I opened up Power BI desktop to have another look at this, I got notfied that a new version was available. Hoping that it would be sorted, I instaled the new version (2.56.5023.942), but the problem is still there.

 

As mentioned above, the error occurs in the first line of the query (source = ...). The Date Modified and Date Created fields are defaulting to a Date/Time type data type as expected. However the cells in both columns show an error. Selecting an individual cell shows this error:

DataFormat.Error: We couldn't parse the input provided as a DateTimeZone value.
Details:
6/03/2018 9:05 a.m.

 

Changing type to anything else (including text, and date/time/timezone with locale set to English (NZ)), still returns the same error. So, I can't get in to manipulate the date field.

 

(I've just tried to do the same thing in Excel, and the data loads correctly...

 

 

 

 

 

 

 

 

 

 

 

 

So, that would seem to indicate that there's a problem with the query engine in Power BI desktop.)

 

 

Any ideas?

 

Michael

Sascha1's avatar
Sascha1
Advocate I
8 years ago

Same issue here. I downgraded to the previous version and it works ok again.

  • eFeM135's avatar
    eFeM135
    Advocate II
    8 years ago

    Actually, I reported this issue on 13th of March with a silly proposal to change regional settings... they should know what the impact is on power queries... look here