SharePoint Folder Connector - Really Slow with data issue

[powerbi_jenhen]

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.

[ppm1]

Not sure how many files you are combining but FYI that you can use incremental refresh with SharePoint files too.

(4) Incremental Refresh with SharePoint Files - YouTube

Pat