SharePoint Folder Connector - Really Slow with data issue

Hi,

I am attempting to use the sharepoint folder connector to consolidate multiple files of data into one query output. This seems to work ok but I noticed cell values with decimal numbers, for example: 0.01 was evaluated as null? Any thoughts?

I also converted the connectors M code from "SharePoint.Files" to "SharePoint.Contents" but I couldn't authenticate via "ApiVersion = 15", once I changed this to "ApiVersion = 14" it took an age to load the data so wasn't usable. Is there any workaround to what I'm trying to achieve as I would much rather store my files in SharePoint rather than a network drive location but I can't find a workable solution for this....annoying to say the least!

Thanks.