Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago
Status:
New

Dataflows Connecting to Sharepoint Online Files

Hi All    I have a problem with my dataflow, it was working fine until yesterday and now it keeps failing.   I've created a connection using SharePoint.Files( "", [ApiVersion = 15] ) this was...
Data Modeling
eFeM135's avatar
eFeM135
Icon for Advocate II rankAdvocate II
6 years ago

It is my impression that the locale and timezone of my sharepoints ( Site Settings / Site Administration / Regional Settings ) changed from Dutch (Netherlands) back to English (US). As a result the local is back to the Microsoft default (en-US) mm/dd/yyyy instead of the expecte (nl-NL) dd/mm/yyyy, introducing the well known issues with API Version 15 again (https://community.powerbi.com/t5/Issues/Date-bug-with-Sharepoint-file-sources/idi-p/384517 ).

I suggest you ask your site administrator to validate settings and verify whether this solves your problem.

Completed Ideas