After updating to March 2018 version of PBI desktop, the Sharepoint folder integration is off when it comes to the Date modified and created.
The error shown is:
DataFormat.Error: We couldn't parse the input provided as a DateTimeZone value.
2/26/2018 1:01 AM
I have tried to change the the data type to "Using Locale..." but without luck.
Solved! Go to Solution.
According to error message, it seems like you are try to convert date value to datetimezone but failed.
Did these values works in normal data type? Can you please share a part of sample data for testing?
Hello @v-shex-msft, thanks for the reply. The problem is that I am not trying to convert anything, this is how it looks when the data is pulled in from Sharepoint folder.
Already when the query is presented before editing the query, it shows errors for most dates. This wasn't the case before the March update. Does it have something to do with the regional settings of Power BI?