Forum Discussion

kimmend's avatar
kimmend
Frequent Visitor
8 years ago
Solved

Sharepoint folder date problem

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 pa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi kimmend,

 

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?

 

Regards,

Xiaoxin Sheng

  • kimmend's avatar
    kimmend
    Frequent Visitor
    8 years ago

    Hello Anonymous, 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?