Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When you use [ApiVersion = 15] as an argument in SharePoint.Files in Power Query and the locale is not US, then you get errors like below:
There is no issue when you use [ApiVersion = 14], but what's the point of reverting back to old version?
Just to be clear, I'm in Australia, and we're using the DMY date format. I'm not doing any transformations -- I am getting those errors right after I connect to SharePoint (there's no step that transforms data types). I have not checked whether other SharePoint.* functions are affected -- have no interest in that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.