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
mgp4444's avatar
mgp4444
Regular Visitor
7 years ago

I haven't been able to find any workaround for this issue -- so basically I can't pull 'date created' from a sharepoint folder source.  This is a significant impact/issue.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    So I've come across this problem, but can't seem to find a solution.  The last post here was six months ago.  Is there a workaround?  I tried changing the API to 14 but got a data source error instead.

    • eFeM135's avatar
      eFeM135
      Advocate II
      7 years ago

      The work-around I used is to set the regionalization on my sharepoint consistent with the one I'm using in Power BI, since my hunch is that the API is having issues when having different date formats (ie. mm/dd/yyyy versus dd/mm/yyyy)... eventual timezone shift you still can compensate in your power query logic.

       

      I still don't understand why the Power BI support team needs votes to resolve bugs that harm global implementations.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks for the tip.  I was able to get it to work.

        I think part of the problem about getting this fixed is that it's marked "Solved" when it so clearly isn't.

         

        thanks,