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

Anonymous 

Thanks for your instructions, but it's not working for me. 

 

Even before I "change type, using locale.." there is an error reported in the dates columns from the sharepoint.files line:

 

 

 

 

so I believe there's something broken when getting the data via the sharepoint.files command.  I can get other date columns to behave correctly, and I've managed to replace what I was after with a sharepoint.tables query.  The sharepoint.tables query takes a while to run, so I'd prefer to go back to the sharepoint.files command.

 

Anything else I could try?

 

Michael

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I have the same problem.  Working before.  not working now.  shows an error when at the SOURCE step.   change local to Welsh, which matches the exact format of the data 15/02/2017 13:06 but the error persists.