SharePoint Implementation 2.0 Does not get Datetime seconds values

[JSpradlin]

When bringing in Datetime columns from SharePoint, including the standard "Created" and "Modified" columns, there are no seconds included, and is instead rounded to the nearest minute. When manually changing the source in Power Query to "ApiVersion=15", the seconds are brought in just fine.

[Anonymous]

Hi  @JSpradlin ,

I would like to know if you are connecting to a SharePoint folder or a SharePoint list? Or a SharePoint file?

Best regards.
Community Support Team_Caitlyn

[JSpradlin]

I'm connecting to a SharePoint list.

If I choose the connector called "SharePoint list", I do not get to choose the implementation version, and it seems to connect using [ApiVersion = 15]. Seconds are shown properly.

If I choose the connector called "SharePoint Online List", it allows me to choose the implementation. Implementation 1.0 is identical to the previous connector. If I choose implementation 2.0, this is how the source looks. Seconds from datetime columns are not being retrieved.

 

[JSpradlin]

Also, I understand the time zone is not being converted with the older implementation. It seems with implementation 1.0, all columns are brought in as text, then the data formatting is done within Power Query. With 2.0, columns are being brought in as their actual data types.